# Glide doesn't show all the data from Sheets

**URL:** <https://community.glideapps.com/t/glide-doesnt-show-all-the-data-from-sheets/45412>\
**Category:** Ask for Help\
**Created:** [July 28, 2022, 10:02am UTC](https://community.glideapps.com/t/glide-doesnt-show-all-the-data-from-sheets/45412 "2022-07-28T10:02:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Moonstone\_Coloured](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moonstone_coloured/32/35548_2.png) [@Moonstone\_Coloured](https://community.glideapps.com/u/Moonstone_Coloured)\
**Post date:** [July 28, 2022, 10:02am UTC](https://community.glideapps.com/t/glide-doesnt-show-all-the-data-from-sheets/45412/1 "2022-07-28T10:02:05Z")

</div>

Hello!  
I constantly face the same issue with updating data from Google Sheet. I noticed, that not all the data are shown in Glide. One column in my Google Sheet contains IMPORTRANGE formula which imports data from another table. When I visit my table, I can see all the data in this column but in Glide some latest data (in the last rows) is not shown.

This is a very annoying issue and I couldn’t find any solutions on the web. Please help to fix it.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [July 28, 2022, 12:24pm UTC](https://community.glideapps.com/t/glide-doesnt-show-all-the-data-from-sheets/45412/2 "2022-07-28T12:24:02Z")

</div>

If you do an advanced search for “importrange” in the forum, you’ll find posts that address exactly this issue.

If I recall correctly, either importrange is better avoided or there might be a delay.

I personally had made a mental note to opt for the first option, avoid importrange.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [July 28, 2022, 3:16pm UTC](https://community.glideapps.com/t/glide-doesnt-show-all-the-data-from-sheets/45412/3 "2022-07-28T15:16:41Z")

</div>

Hola!

Let me imagine your scenario:  
1- your GS is updated in background by an external source (e.g. ImportRange()), right?  
2- when you open your APP, you can’t see the newer data, right?  
3- If you press **Sync button** in Glide Data Editor, everything is synchronized and your problem disappears, right or not?

If so, this a normal behavior if you have a Free plan. Pro plans have a feature to enable these updates automatically. More info [here](https://docs.glideapps.com/all/topics/faq/data-refresh)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 28, 2022, 12:13pm UTC](https://community.glideapps.com/t/glide-doesnt-show-all-the-data-from-sheets/45412/4 "2022-12-28T12:13:31Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
