# Hit 500/500 by accident and cant undo it!

**URL:** <https://community.glideapps.com/t/hit-500-500-by-accident-and-cant-undo-it/10172>\
**Category:** Ask for Help\
**Created:** [June 2, 2020, 11:00am UTC](https://community.glideapps.com/t/hit-500-500-by-accident-and-cant-undo-it/10172 "2020-06-02T11:00:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevyn\_Levine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevyn_levine/32/7902_2.png) [@Kevyn\_Levine](https://community.glideapps.com/u/Kevyn_Levine)\
**Post date:** [June 2, 2020, 11:00am UTC](https://community.glideapps.com/t/hit-500-500-by-accident-and-cant-undo-it/10172/1 "2020-06-02T11:00:48Z")

</div>

Hello friends! In my google sheet i had dropped a VLOOKUP formula “all” the way down to infinity which caused me to hit my 500 rows, then i deleted that column from my google sheet but the 500/500 never dropped back down to the 120ish i was at. I reviewed all tabs from my google sheet and the data tab within glide and no formulas extend beyond what i originally had before my aforementioned mistake. I tried reloading the data multiple times.

Any other suggestions?

---

<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 2, 2020, 11:01am UTC](https://community.glideapps.com/t/hit-500-500-by-accident-and-cant-undo-it/10172/2 "2020-06-02T11:01:26Z")

</div>

Are you sure you don’t have any VLOOKUPs or ARRAYFORMULA populating the rows in the wrong way?

---

<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:** [June 2, 2020, 11:17am UTC](https://community.glideapps.com/t/hit-500-500-by-accident-and-cant-undo-it/10172/3 "2020-06-02T11:17:46Z")

</div>

Hi @Kevyn_Levine, have you tried deleting the rows (not just clearing the data) that you don’t need? It is a good practice to limit the size of your spreadsheet by limiting empty rows and columns. Try deleting, sync, maybe that will help?