Published version of Google Sheets/Docs not updating

Question

Published version of Google Sheets/Docs not updating

tpmccallum opened this issue 10 years ago · 13 comments

Hi,
This is probably more of a browser cache issue but I would like to find a way to ensure that changes made to my sheet are reflected in the web page (web component).

Google Sheet:
I find that the published version of my sheet (or doc for that matter) are not reflecting the edit version of my sheet (when refreshing the published version of the sheet; works properly upon creation of a sheet).

Web Component:
I am seeing a similar thing happen in the web component and wonder if we can add some javascript (inside the web component) to force a refetch of content from the published version of the sheet.

Thanks a bunch you guys,
Chat soon
Tim

acotton-ipd commented 7 years ago

same

Answer 1 · 2014-12-18T04:02:30.000Z

For published sheets, I typically have to stop publishing then re-publish it. The web components should pick up the changes then. The same is true for the embed link Google Sheets gives you. Do I understand your question correctly?

Answer 2 · 2015-03-18T17:41:02.000Z

Closing as this is old.

Answer 3 · 2016-02-25T06:01:30.000Z

Hi,
I currently am going through the same problem.
I have a dashboard created in Google Sheets and it contains multiple charts.
I chose to publish it to web, while generating the link to embed only the sheet containing the dashboard, and publishing all content to web.
The dashboard is dynamic, since it consumes data from a Google Form.
When I submit a new response, the actual sheet gets updated instantly, all fine and dandy, but when I go to the sheet embedded in my web page, it still shows stale data.

Stopping publishing and republishing is not an option for me.

Does the "Automatically republish when changes are made." checkbox mean nothing?

Any solutions\responses are welcome.

Thanks,
Sujay

Answer 4 · 2017-02-23T23:40:23.000Z

I'm having the same issue. :-/ My published Google Doc is not updated. I tried to stop publishing and republish and it is not updating.

Answer 5 · 2017-03-27T11:54:21.000Z

I am also facing the same issues. I had tried Stop Publishing and then Republish the sheet. But the front end is not taking the updated result. Any help will be appreciated.

Answer 6 · 2018-01-10T15:18:10.000Z

Same problem here +1

Answer 7 · 2018-01-16T17:35:48.000Z

Facing same issue +1

Answer 8 · 2018-03-17T11:00:06.000Z

Same problem here. Even If I use embedding plugins, or reading data from public urls, the changes only appears in 4-6 minutes after being made.

Answer 9 · 2018-06-23T14:34:11.000Z

Yes, that is correct, published charts in Google Sheets only update 5 minutes after a change was made.

Here's a different but very simple approach to make a chart update instantly: https://medium.com/@steynviljoen/how-to-share-or-embed-a-google-sheets-chart-that-updates-instantly-no-need-to-wait-for-5-minutes-b6d325cd8598

Answer 10 · 2021-01-16T19:59:48.000Z

@steynvil I reviewed your article, but my chart URL does not contain the "edit#" and my chart is its own sheet so I was not able to make your instructions work.

Answer 11 · 2021-05-21T23:44:28.000Z

Hi, i am having the same problem, in my case, when I open the google sheet public url with a guest user (in chrome browser) I do see the updated sheet, but when i use my regular user it shows a previous version of the sheet

Answer 12 · 2021-10-01T03:02:36.000Z

Im having the same issue.