# Glide Data Disappeared Twice-Wondering why? **URL:** \ **Category:** Report a Bug\ **Created:** [September 13, 2020, 11:49pm UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747 "2020-09-13T23:49:44Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![JT75](https://avatars.discourse-cdn.com/v4/letter/j/90ced4/32.png) [@JT75](https://community.glideapps.com/u/JT75)\ **Post date:** [September 13, 2020, 11:49pm UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/1 "2020-09-13T23:49:44Z")
Hi, This has now happened two days in row, so i assume there is some limitations to Glide and importhtml. I had the following: An auto refreshing (script enabled) importhtml function. I then have it related to another sheet (along with others).Then it is related to another sheet with lookups etc. I have a Number of lookups, and they all just disappear. However, the other columns and relations don’t. THese are just the ones specific to my updated sheet (google sheets). Is anyone aware of these issues? I dont want to put in these AGAIN, and have it disappear, however, I am dumbfounded how or why it is happening? Any thoughts, or workarounds would be appreciated. ---
**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:** [September 14, 2020, 1:02am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/2 "2020-09-14T01:02:32Z")
What type of data does your IMPORTHTML function get back? ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 14, 2020, 1:06am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/3 "2020-09-14T01:06:38Z")
Is the IMPORTHTML causing your column headers to change or change their order? ---
**Author:** ![JT75](https://avatars.discourse-cdn.com/v4/letter/j/90ced4/32.png) [@JT75](https://community.glideapps.com/u/JT75)\ **Post date:** [September 14, 2020, 1:16am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/4 "2020-09-14T01:16:36Z")
no - not the order nor the name. the script removes and replaces the importhtml so it refreshes. ---
**Author:** ![JT75](https://avatars.discourse-cdn.com/v4/letter/j/90ced4/32.png) [@JT75](https://community.glideapps.com/u/JT75)\ **Post date:** [September 14, 2020, 1:22am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/5 "2020-09-14T01:22:48Z")
as for the type of data - just text…and numbers including negative numbers ---
**Author:** ![JT75](https://avatars.discourse-cdn.com/v4/letter/j/90ced4/32.png) [@JT75](https://community.glideapps.com/u/JT75)\ **Post date:** [September 14, 2020, 1:42am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/6 "2020-09-14T01:42:57Z")
should i import range from that sheet? and when it refreshes - maybe it wont delete every relation? it works for a bit, but then it stops. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 14, 2020, 2:12am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/7 "2020-09-14T02:12:44Z")
Glide writes metadata into your sheet columns to track them, your script may be deleting that when it replaces them. ---
**Author:** ![JT75](https://avatars.discourse-cdn.com/v4/letter/j/90ced4/32.png) [@JT75](https://community.glideapps.com/u/JT75)\ **Post date:** [September 14, 2020, 2:14am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/8 "2020-09-14T02:14:38Z")
mmm - ok. so now what? ---
**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:** [September 14, 2020, 5:03am UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/9 "2020-09-14T05:03:08Z")
I have found that if headings are part of an import, you can have issues with glide losing track of the columns. To get around that I restructured my sheet to have permanent headings, and move the import to the second row in the sheet. If the import still brings in headings to the second row, you can simply ignore that row with a filter. ---
**Author:** ![JT75](https://avatars.discourse-cdn.com/v4/letter/j/90ced4/32.png) [@JT75](https://community.glideapps.com/u/JT75)\ **Post date:** [September 14, 2020, 12:38pm UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/10 "2020-09-14T12:38:08Z")
THANK YOU! thats what i was looking for…appreciate it. 1) the filter being in the actual google sheet correct? not in the glide editor? 1. would importrange work be a decent workaround? or probably suffer the same issues. THANKS AGAIN JEFF!!! ---
**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:** [September 14, 2020, 12:52pm UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/11 "2020-09-14T12:52:13Z")
As long as you don’t touch the header I think that’s fine. He means the filter in Glide where you filter out the header I think. ---
**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:** [September 14, 2020, 1:13pm UTC](https://community.glideapps.com/t/glide-data-disappeared-twice-wondering-why/15747/12 "2020-09-14T13:13:42Z")
Yes, what @ThinhDinh said. My case was when I used ImportRange, but should be the same concept. I was able to skip grabbing the headers from the other sheet by changing the range used in ImportRange, but I’m not sure if you can avoid that with ImportHTML.