Excel not syncing properly

Report a Bug
1

My App/Pages Support link:
https://go.glideapps.com/support/e1593f6c-e976-4c74-a7fc-c25f7b18cd2a

Describe the bug:
Hi, I created a new team and started a new free app project based on an Excel Workbook. At some point, I noticed my Excel workbook is not syncing on one tab. I did a row count and found I was using well over 500 rows (I had not yet normalized my tables). Under the Usage Window, however, Glide is reporting I was only using 310 rows. At any rate, I normalized my tables and got down to 300 rows. Then I removed the tab from excel that was causing my row count to exceed 500.

When I refreshed my browser, Glide had converted the deleted Excel tab to a Glide table and retained the data!

image

And it is still not syncing my last tab which has 20 or so rows in it…

Expected Behaviour:
What should happen?
Glide should be able to do an accurate row count and sync my table. I don’t mind that it retained the data as a Glide table when I removed the tab from Excel. I can always delete that later – I consider that a feature! But I need it to sync properly with excel. The “Rosary Prayers” table is not syncing all the rows.

How to replicate:
Describe in detail how to recreate the issue
It’s still like that.

I also notice if you duplicate an app with tables, it converts all the tables to Glide tables instead of copying your Excel workbook to a new workbook.

1 Like
2

I am experiencing the same problem since 2 days. My data source is google sheets.

First I thought the problem is with a particular app, but I experienced this error in my other app as well which is in a different team.

Definitely a major bug!!!

3

Your SV table that is a Glide Table is not being referred in the app in any way. So it does not count as row usage.

4

Hi Santiago,

The Glide Table that is there was an Excel tab, and it was being referenced by relations, and Glide still was not counting those rows in the usage. When I normalized the data by bringing it into the other sheets and deleted the tab from Excel, Glide transformed it into a Glide Table and kept all the data. I was going to delete that also, but wanted support to be able to see what I was talking about.

So, and I still have the problem that the Excel workbook is not syncing with my Glide tables.

David

5

What is the table that is not syncing?

Do you have a video of it?

6

Rosary Prayers (in Glide)

image
image937Ă—448 69.9 KB

In Excel

image
image808Ă—434 35.2 KB

7

@David_Gabler could you delete that table from your app?

1 Like
8

OK, deleting the spurious Glide Table that was created by Glide when I removed the corresponding Excel Tab allowed the other table to update on the Glide side.

Thank you for your help.

1 Like
9

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.