# Removed a lot of columns and now i cannot refresh sheet

**URL:** <https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928>\
**Category:** Report a Bug\
**Created:** [June 16, 2020, 12:58am UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928 "2020-06-16T00:58:45Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [June 16, 2020, 12:58am UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/1 "2020-06-16T00:58:45Z")

</div>

I am running into a problem when trying to refresh the sheet inside the glide editor…  
when i removed a lot of columns to shift things around, now it wont save because the confirmation is too large… any ideas? It could just be my fault for not scaling out the changes inside the sheet… but…

Help! Any other way to refresh the sheet?

Sorry for the blurred out text i hope to share the app with everyone when finished

---

<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:** [June 16, 2020, 1:12am UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/2 "2020-06-16T01:12:23Z")

</div>

Can you try duplicating the app and pointing to the same sheet?

---

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [June 16, 2020, 4:50pm UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/3 "2020-06-16T16:50:41Z")

</div>

Good suggestions but For some reason that does not work because it still asks for me to refresh the sheet…

---

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [June 16, 2020, 4:52pm UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/4 "2020-06-16T16:52:35Z")

</div>

![bigbug](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/486b22e513f46cad294ecb2a377124327ec2b4d1.jpeg) still giving me the need to refresh the sheet

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [June 16, 2020, 6:24pm UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/5 "2020-06-16T18:24:35Z")

</div>

Could you try zooming out in your browser until you see the confirmation button? 😉

---

<div class="post-metadata">

**Author:** ![XL-STEAMS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xl-steams/32/8784_2.png) [@XL-STEAMS](https://community.glideapps.com/u/XL-STEAMS)\
**Post date:** [June 16, 2020, 8:06pm UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/6 "2020-06-16T20:06:43Z")

</div>

Hi there! I am having the same issue, I think. I added a new tab in Google sheets and it hasn’t refreshed in the app. It’s been like 4 hours. Is there a max to how many tabs you can have in Google sheets? I currently have 5 (wanted to add a 6th one). Any other ways to refresh other than duplicating the app (because I tried that and I had the same issue in the duplicated one…)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 16, 2020, 9:31pm UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/7 "2020-06-16T21:31:30Z")

</div>

Does the new sheet at least have headings in the first row? Did you try to add a new tab in glide pointing to the new sheet?

---

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [June 16, 2020, 10:34pm UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/8 "2020-06-16T22:34:33Z")

</div>

Hey guys… what i ended up doing was just rebuild the entire app …i couldn’t figure out a way to refresh in this state so i just went for it…

---

<div class="post-metadata">

**Author:** ![XL-STEAMS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xl-steams/32/8784_2.png) [@XL-STEAMS](https://community.glideapps.com/u/XL-STEAMS)\
**Post date:** [June 16, 2020, 10:58pm UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/9 "2020-06-16T22:58:19Z")

</div>

Yes, the first row has headings. I even have a row of data inputted. I tried to add a new tab in glide, but it doesn’t show… therefore, I am not able to point it to the new sheet.

Here, are a few screenshots: 1) my spreadsheet with the tab titled, “Essentials” with a headings row and a row of data 2) inside the glide app’s tab feature —where you see me looking for the “Essential” that is not currently there

 ![Screen Shot 2020-06-16 at 3.55.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/ce82b16b617c3c863ae80495154655fc2e993c53.png) ![Screen Shot 2020-06-16 at 3.55.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bacdf78ecea244071cd4463a70ad27cd25ed4586.png)

---

<div class="post-metadata">

**Author:** ![XL-STEAMS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xl-steams/32/8784_2.png) [@XL-STEAMS](https://community.glideapps.com/u/XL-STEAMS)\
**Post date:** [June 17, 2020, 3:42am UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/10 "2020-06-17T03:42:42Z")

</div>

…I even tried restoring my spreadsheet from yesterday (before it became unresponsive)… still no luck! Have this happened to anyone else? I really don’t want to but it all over again…

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 18, 2020, 4:17am UTC](https://community.glideapps.com/t/removed-a-lot-of-columns-and-now-i-cannot-refresh-sheet/10928/11 "2020-06-18T04:17:41Z")

</div>

Does the sheet reload button on the left hand side have a yellow triangle? That usually indicates something is not matching between glide and your sheet. There also seems to be some weird issues going on over the past day. I had one with mine where it wouldn’t sync because Glide said a column was missing that a component was referring to. I could see the column in the sheet and the data editor, but I just ended up changing the column that the component referred to, let glide think it was deleting any components that were referring to the missing column, then switch to component back to the original column. It seems like a few bugs were introduced this past week.

For something to try, make a duplicate of your app and see if you can get the new sheet to show up.
