Solved: Google Sheets Loading Error - Page 2

JonathanSh · 07-22-2024 08:03 AM

Hi,

I have a Google Sheet who is connected to BigQuery and it's usually updating on a daily basis.

It's currently stuck in updating mode.

How can I stop the loading and fix this issue?

Few notes - The BQ table itself is running fine.

When I copied the GS it worked.

jeerahalli

My first recommendation would be to do all of these troubleshooting steps:

- Clear cache and cookies of the Chrome Browser with these instructions https://support.google.com/accounts/answer/32050.

- Try on an incognito window, you can use this article as a guide https://support.google.com/chrome/answer/95464.

- Try to disable Chrome extensions as they could be messing the loading process.

- If you use a proxy or firewall add these ports and hosts to your configuration https://support.google.com/a/answer/2589954.

- Try on different browsers like Firefox, Edge, or Safari.

- If you use a Chromebook, try to verify if on another computer (Windows or Mac) the issue reproduces.

- Try making a copy of the Google Sheet, verify if the copy has the same behavior.

- If you are loading large sheets with complex formulas, mostly if they retrieve data from external spreadsheets, the delay when it retrieves the data could cause formulas to fail so is recommended to use smaller spreadsheets or divide the data in other spreadsheets to avoid loading issues.

View solution in original post