# Excel Data Disappears

**URL:** <https://community.glideapps.com/t/excel-data-disappears/49500>\
**Category:** Report a Bug\
**Created:** [September 17, 2022, 3:27am UTC](https://community.glideapps.com/t/excel-data-disappears/49500 "2022-09-17T03:27:22Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [September 17, 2022, 3:27am UTC](https://community.glideapps.com/t/excel-data-disappears/49500/1 "2022-09-17T03:27:22Z")

</div>

**My App/Pages Support link:**  
[https://go.glideapps.com/support/4a7b1564-6af4-40ed-9d91-d58d2d1bb46c](https://go.glideapps.com/support/4a7b1564-6af4-40ed-9d91-d58d2d1bb46c)

**Describe the bug:**  
After entering data using my app into Excel, the data shows in my app, but not in Excel. If I exit the app and go back in, the data is gone in Glide, but the Row ID is there in Excel.

**Expected Behaviour:**  
The data should sync to Excel and stay in the app.

**How to replicate:**  
Enter some data under “circuits” – a three-column table in a one-tab Excel spreadsheet, where only one column is required besides the Row ID.

**Demonstration:**

During the beta phase of Excel, I had an app where I spent the afternoon entering about 150 rows in an excel spreadsheet which was attached to an app. About half the rows ended up with columns of missing data (the rows were still there).

I submitted that, but Glide’s tech team was unable to find anything conclusive.

Since this test app and table is so simple, and it can be reproduced at will, hopefully it will provide a better example of what is going on with Excel.

I just copied the app to a new app, and of course Glide converted the Excel Table to a Glide Table. That was expected. I tried the same thing using the new app and the data stays in place (also expected).

---

<div class="post-metadata">

**Author:** ![Jakob\_Norby](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jakob_norby/32/54650_2.png) [@Jakob\_Norby](https://community.glideapps.com/u/Jakob_Norby)\
**Post date:** [February 20, 2023, 9:28pm UTC](https://community.glideapps.com/t/excel-data-disappears/49500/2 "2023-02-20T21:28:26Z")

</div>

I have experienced the same in my app. Did you come up with any solution to the problem?

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [February 20, 2023, 10:36pm UTC](https://community.glideapps.com/t/excel-data-disappears/49500/3 "2023-02-20T22:36:30Z")

</div>

No unfortunately this has not been Addressed. I have not seen a resolution to the problem. I have seen several people report similar issues. Not sure if they know what’s going on

---

<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:** [February 21, 2023, 12:09am UTC](https://community.glideapps.com/t/excel-data-disappears/49500/4 "2023-02-21T00:09:22Z")

</div>

Since the last time we talked about this issue, it happened once again to me and we have to connect the table again. I’m not sure if they deployed a fix or not but it has been stable for the last 2 weeks.

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [February 21, 2023, 12:44am UTC](https://community.glideapps.com/t/excel-data-disappears/49500/5 "2023-02-21T00:44:27Z")

</div>

Well it is easy to reproduce so I’ll try again tomorrow. I really do need the excel to work.

---

<div class="post-metadata">

**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\
**Post date:** [June 29, 2023, 5:27pm UTC](https://community.glideapps.com/t/excel-data-disappears/49500/6 "2023-06-29T17:27:46Z")

</div>

Noticed you on this thread. I have recently had this happen whenever I added new columns to an excel table. After syncing the column shows up but I am unable to save data entered in Glide to the new Excel columns. The data disappears in the Glide interface. All the original columns work fine.  
Is the solution to disconnect and then reconnect the Excel table?  
hat happens to all my screen builds?

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [June 29, 2023, 6:01pm UTC](https://community.glideapps.com/t/excel-data-disappears/49500/7 "2023-06-29T18:01:09Z")

</div>

> [@GrumpyRick](#):
>
> The data disappears in the Glide interface.

@ThinhDinh says above that reconnecting the sheet solves the problem. I don’t know. I had an App that reliably reproduced the issue, but I gave up fighting the Excel problems and have not tried in a while. I also have never tried using a new App. I have only tried it with Classic Apps – although I am not certain that would make a difference, since it’s the data editor which both types of Apps have in common.

---

<div class="post-metadata">

**Author:** ![Hobe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hobe/32/55866_2.png) [@Hobe](https://community.glideapps.com/u/Hobe)\
**Post date:** [June 29, 2023, 10:23pm UTC](https://community.glideapps.com/t/excel-data-disappears/49500/8 "2023-06-29T22:23:20Z")

</div>

I wouldn’t try that, these days I asked what would happen if the glide lost synchronization with my excel, in a microsoft user password change for example, nobody knew how to answer me. So, I have the impression that tables in the glide environment would turn into native glide tables.

---

<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 29, 2023, 11:40pm UTC](https://community.glideapps.com/t/excel-data-disappears/49500/9 "2023-06-29T23:40:19Z")

</div>

By re-connecting the table, I had to configure all my computed columns again so it was not very pleasing. My data is read-only, so I’m not sure about not being able to enter data from Glide to Excel. Probably worth a support ticket.

Another question for @GrumpyRick though, if you change the data via the data view instead of a component on the front end, does it work?

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [June 30, 2023, 1:40am UTC](https://community.glideapps.com/t/excel-data-disappears/49500/10 "2023-06-30T01:40:33Z")

</div>

> [@ThinhDinh](#):
>
> change the data via the data view instead of a component on the front end, does it work

In my experience, it doesn’t matter whether it’s through the data view or through a form. In the dat view, you could literally sit there and watch the fields disappear.

---

<div class="post-metadata">

**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\
**Post date:** [June 30, 2023, 5:04am UTC](https://community.glideapps.com/t/excel-data-disappears/49500/11 "2023-06-30T05:04:02Z")

</div>

Answer to your question is no…there was no difference.

My client went ahead and created a new table with all the needed fields. I then had to recreate all the calculation fields and updates al; screens, forms, and actions using the new table. Took all evening but no it works .  
Hope they do not need a new field down the road.

---

<div class="post-metadata">

**Author:** ![Hobe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hobe/32/55866_2.png) [@Hobe](https://community.glideapps.com/u/Hobe)\
**Post date:** [June 30, 2023, 11:17am UTC](https://community.glideapps.com/t/excel-data-disappears/49500/12 "2023-06-30T11:17:46Z")

</div>

For your problem, it was enough to delete the column with the problem and create a new one, as I had suggested in another topic, this bug does not happen in every new column that you need to create, it is something that rarely happens.

---

<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 30, 2023, 11:03pm UTC](https://community.glideapps.com/t/excel-data-disappears/49500/13 "2023-06-30T23:03:08Z")

</div>

At this point, I would suggest submitting a ticket.

> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2):
>
> Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link:

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [July 1, 2023, 3:53am UTC](https://community.glideapps.com/t/excel-data-disappears/49500/14 "2023-07-01T03:53:03Z")

</div>

> [@ThinhDinh](#):
>
> would suggest submitting a ticket.

I submitted a ticket about this long ago, so if someone else does also, they’ll have another app to look at as well.
