# Spreadsheet not updated

**URL:** <https://community.glideapps.com/t/spreadsheet-not-updated/13448>\
**Category:** Report a Bug\
**Created:** [August 2, 2020, 1:04pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448 "2020-08-02T13:04:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexdz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexdz/32/10382_2.png) [@Alexdz](https://community.glideapps.com/u/Alexdz)\
**Post date:** [August 2, 2020, 1:04pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/1 "2020-08-02T13:04:07Z")

</div>

Has anyone experienced this: I insert new data rows via the app, they appear in the data editor and everything works just as expected, however, that new data is nowhere to be found in the spreadsheet?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 2, 2020, 1:05pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/2 "2020-08-02T13:05:31Z")

</div>

Can you scroll all the way down in the Sheets and check if the data is there?

---

<div class="post-metadata">

**Author:** ![Alexdz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexdz/32/10382_2.png) [@Alexdz](https://community.glideapps.com/u/Alexdz)\
**Post date:** [August 2, 2020, 1:07pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/3 "2020-08-02T13:07:03Z")

</div>

wow, you are right, how did you know that?  
Is this a permanent issue? Or can I just copy paste the rows to the top and thats it? Or should I just leave it like this?

---

<div class="post-metadata">

**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\
**Post date:** [August 2, 2020, 1:14pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/4 "2020-08-02T13:14:09Z")

</div>

It has happened to all of us at least once 🙂 I have started deleting any blank rows in between and that fixes any future ‘missing data’ issues.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 2, 2020, 1:36pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/5 "2020-08-02T13:36:35Z")

</div>

When Glide writes data back to the Sheet, a problem with the Google side is that they skip all blank rows despite they are perfectly valid rows, and write to a row like 501 or 1001, way down there. To prevent this, just delete all the empty rows and you’ll be fine.

---

<div class="post-metadata">

**Author:** ![Alexdz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexdz/32/10382_2.png) [@Alexdz](https://community.glideapps.com/u/Alexdz)\
**Post date:** [August 2, 2020, 1:38pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/6 "2020-08-02T13:38:11Z")

</div>

ok, cool, good to know. Never happened to me before, but than again so far I havent made that many apps 🙂

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 2, 2020, 1:45pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/7 "2020-08-02T13:45:11Z")

</div>

It happens when you have array formulas in your sheet.

To prevent this, always delete all the empty rows in your sheet.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 4, 2024, 2:17pm UTC](https://community.glideapps.com/t/spreadsheet-not-updated/13448/8 "2024-02-04T14:17:18Z")

</div>


