# Google Sheet does not match data view in Glide

**URL:** <https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903>\
**Category:** Report a Bug\
**Created:** [November 12, 2019, 6:24am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903 "2019-11-12T06:24:32Z")\
**Posts on this page:** 12\
**Page:** 3

<div class="post-metadata">

**Author:** ![Xavier\_Delplanque](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xavier_delplanque/32/45565_2.png) [@Xavier\_Delplanque](https://community.glideapps.com/u/Xavier_Delplanque)\
**Post date:** [November 26, 2020, 9:47am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/42 "2020-11-26T09:47:14Z")

</div>

> [@ThinhDinh](#):
>
> your Internet connection unstable?

It isn’t :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/4378348beaf2300991b51265375e3e4c540ba110.png)

---

<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:** [November 26, 2020, 10:30am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/43 "2020-11-26T10:30:01Z")

</div>

Just asking that based on the “Editing is temporarily unavailable” message. It’s a Sheet problem and I highly doubt that has anything to do with Glide.

---

<div class="post-metadata">

**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:** [November 26, 2020, 3:50pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/44 "2020-11-26T15:50:05Z")

</div>

Looks like you have a lot of browser extensions. I wonder if some of those are interfering. You could also try incognito mode or another browser to see if that makes a difference.

> <https://webapps.stackexchange.com/questions/33666/why-is-google-drive-convinced-that-im-offline>

---

<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:** [November 26, 2020, 4:10pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/45 "2020-11-26T16:10:58Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/098aa67d4ced15c2571438ac82ccafff9921120c.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/372bce35ed3fc15cf149b2557af9b8ef7a1ef8f8.png)

Just realized the number of extensions I have is out of this world.

---

<div class="post-metadata">

**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\
**Post date:** [November 26, 2020, 4:15pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/46 "2020-11-26T16:15:17Z")

</div>

Can you still contact support? I see a message to only do so if its account or billing related.

---

<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:** [November 26, 2020, 4:32pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/47 "2020-11-26T16:32:22Z")

</div>

Not sure, actually I have never contacted support, just redirected to the official page because this seems not a problem that users can easily fix without viewing the inner settings.

---

<div class="post-metadata">

**Author:** ![Xavier\_Delplanque](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xavier_delplanque/32/45565_2.png) [@Xavier\_Delplanque](https://community.glideapps.com/u/Xavier_Delplanque)\
**Post date:** [December 1, 2020, 12:53pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/48 "2020-12-01T12:53:12Z")

</div>

Hi Jeff,

Thanks for your answer.  
I ended up sharing the spreadsheet with a link as editor, and opened it in incognito.  
I could edit an older version of the spreadsheet, and this time the sync worked with Glide.  
So it looks like the version in my account is out of sync and that’s why the data didn’t match.  
I still need to find out how to revert to the latest synced version in my account, but that’s a Google drive issue, not a Glide’s one.

I’m still wondering if the connection with Glide didn’t lead to this syncing issue since that’s the first it happened to me. It maybe worth investigation if you receive more reports.

Thanks again!

---

<div class="post-metadata">

**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:** [December 1, 2020, 2:28pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/49 "2020-12-01T14:28:11Z")

</div>

I’m really not sure what could be the problem. Might be a question to ask on a google forum. My only guess is that you have an extension or firewall blocking the syncing of your local copy of the sheet to the Google servers. I’ve never experienced anything like that, so I’m not sure. You could try duplicating your app with and without the same sheet. Also try duplicating your sheet and setting your copied app to point to that new sheet. Otherwise, I’m just not sure. Worst case you may have to manually copy data to a new sheet and switch your app over to that new sheet.

---

<div class="post-metadata">

**Author:** ![Hello\_Mars](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hello_mars/32/17443_2.png) [@Hello\_Mars](https://community.glideapps.com/u/Hello_Mars)\
**Post date:** [December 14, 2020, 6:43am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/50 "2020-12-14T06:43:19Z")

</div>

I’m having similar issue. Google sheets have 3 items while Glide data has 8. The first 3 items actually syncs properly, but the extra 5 items in Glide just wouldn’t budge.

> **[MyBooks](https://mybooks1137.glideapp.io/)**
>
> A book sharing app

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

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/36e06c077058be59a15084772b13134b9a52f3b7.png)

---

<div class="post-metadata">

**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:** [December 14, 2020, 7:04am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/51 "2020-12-14T07:04:21Z")

</div>

Scroll down to the bottom of the sheet.

> [@Have users record their pronunciation](https://community.glideapps.com/t/have-users-record-their-pronunciation/8731/8):
>

> [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727):
>
> Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 
> 
> > **1/ Definition**
> >
> > Arrayformula is defined as “a range, mathematical expression using one cell range …

---

<div class="post-metadata">

**Author:** ![Hello\_Mars](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hello_mars/32/17443_2.png) [@Hello\_Mars](https://community.glideapps.com/u/Hello_Mars)\
**Post date:** [December 16, 2020, 5:40am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/52 "2020-12-16T05:40:37Z")

</div>

Also found a tutorial

> **[ARRAYFORMULA](https://docs.glideapps.com/all/reference/using-sheets/functions/arrayformula)**
>
> a.k.a. ARRAYFORMULA

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [October 2, 2023, 2:23pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/53 "2023-10-02T14:23:15Z")

</div>



[Previous page](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903.md?page=2)
