# Glide doesn't load a G. Sheet

**URL:** <https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456>\
**Category:** Ask for Help\
**Created:** [October 11, 2022, 9:41am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456 "2022-10-11T09:41:54Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 11, 2022, 9:41am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/1 "2022-10-11T09:41:54Z")

</div>

Suddenly, why is there only one sheet not loading data from the G. sheet while other sheets can?

---

<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:** [October 11, 2022, 9:49am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/2 "2022-10-11T09:49:08Z")

</div>

- Have you tried refreshing the sync in the data editor?
- Did you change something to the buggy sheet recently?
- If the sheet happens to be new, is it structured correctly with at least one column and a column header?
- Have you tried adding a new sheet to see if that new sheet syncs with Glide correctly? If so, maybe you could move over the data to the new sheet that’s not buggy.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 11, 2022, 9:57am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/3 "2022-10-11T09:57:36Z")

</div>

Since I’m using importrange I added one definite title in case the title fails. Is this the cause? But it’s been working for a quite long time. Any idea how to fix it?

 ![Screenshot 2022-10-11 165210](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb0e42baf1d8355269b812f3e6c54823c9b190ab.png)

---

<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:** [October 11, 2022, 10:18am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/4 "2022-10-11T10:18:16Z")

</div>

Yes, that’s a common issue with importrange.  
Adding a static header row is the way to fix it.  
Although I see you have the header row duplicated. What I would suggest is modifying your importrange formula so that it ignores the first row. ie. start the range at row 2.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 11, 2022, 10:30am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/5 "2022-10-11T10:30:35Z")

</div>

Yes, the first line is the static header. The second line is an importrange starting from the first line/title of another sheet.  
So you mean the second line doesn’t need a title anymore?  
I’m just worried it will be deleted.

---

<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:** [October 11, 2022, 10:32am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/6 "2022-10-11T10:32:30Z")

</div>

Just change your importrange formula. Instead of `A1:...`, make it `A2:...` and then put it in A2

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 11, 2022, 10:36am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/7 "2022-10-11T10:36:19Z")

</div>

Now the only way is to create a new sheet again, no other way to recover it again?

---

<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:** [October 11, 2022, 10:38am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/8 "2022-10-11T10:38:28Z")

</div>

I don’t understand. All you need to do is fix your importrange formula and re-sync the sheet with Glide.

---

<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:** [October 11, 2022, 10:44am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/9 "2022-10-11T10:44:53Z")

</div>

If you’re uncertain about Darren’s recommendation, you can test it on a test sheet first.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 11, 2022, 10:56am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/10 "2022-10-11T10:56:15Z")

</div>

My first title is already static. The formula is also in A2. The difference only takes the title or not with importrange.  
I don’t understand the problem. Does that second title interfere with glide identifying it?  
I’ll try later.

---

<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:** [October 11, 2022, 11:00am UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/11 "2022-10-11T11:00:00Z")

</div>

It could interfere, especially if there’s an incidence on the type of data (text vs number vs boolean for instance) because the structure of a table that can be used as a source of data in Glide is as follows:

- 1st row in the table: column headers
- Subsequent rows in the table (2nd row and beyond): records

The 2nd is not supposed to be a repetition of the first.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [October 11, 2022, 12:32pm UTC](https://community.glideapps.com/t/glide-doesnt-load-a-g-sheet/51456/12 "2022-10-11T12:32:46Z")

</div>

Thanks, for your explanation.

Now it’s suddenly back to normal again after I stayed out for a while and haven’t changed it.

Thank you too @Darren_Murphy
