# Excel not syncing properly

**URL:** <https://community.glideapps.com/t/excel-not-syncing-properly/41252>\
**Category:** Report a Bug\
**Created:** [April 26, 2022, 3:04pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252 "2022-04-26T15:04:04Z")\
**Posts on this page:** 11\
**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:** [April 26, 2022, 3:04pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/1 "2022-04-26T15:04:04Z")

</div>

**My App/Pages Support link:**  
[https://go.glideapps.com/support/e1593f6c-e976-4c74-a7fc-c25f7b18cd2a](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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c935ebf0bd06db085c83ea32f9149b7a52312ff1.png)

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.

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [April 26, 2022, 8:29pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/2 "2022-04-26T20:29:29Z")

</div>

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!!!

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [April 26, 2022, 8:46pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/3 "2022-04-26T20:46:33Z")

</div>

> [@David\_Gabler](#):
>
> [Glide](https://go.glideapps.com/support/e1593f6c-e976-4c74-a7fc-c25f7b18cd2a)

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.

---

<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:** [April 26, 2022, 9:32pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/4 "2022-04-26T21:32:24Z")

</div>

> [@SantiagoPerez](#):
>
> 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.

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

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [April 26, 2022, 9:35pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/5 "2022-04-26T21:35:25Z")

</div>

What is the table that is not syncing?

Do you have a video of it?

---

<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:** [April 26, 2022, 9:38pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/6 "2022-04-26T21:38:01Z")

</div>

Rosary Prayers (in Glide)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b5946bc05e5efd38ddad913147e67add07cf961e.png)

In Excel

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1dffb29189bd17663e4a544123be615f808923ce.png)

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [April 27, 2022, 12:27am UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/7 "2022-04-27T00:27:27Z")

</div>

@David_Gabler could you delete that table from your app?

---

<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:** [April 27, 2022, 12:51am UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/8 "2022-04-27T00:51:59Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 28, 2022, 12:52am UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/9 "2022-04-28T00:52:49Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 27, 2022, 10:29pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/10 "2022-05-27T22:29:38Z")

</div>



---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 27, 2022, 10:29pm UTC](https://community.glideapps.com/t/excel-not-syncing-properly/41252/11 "2022-05-27T22:29:39Z")

</div>


