You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a set of Google Sheets that use GoogleFinance, the sheets can take 10 seconds to fully load the data and update. Most update fine and I can access via the https://opensheet.elk.sh urls.
But sometimes the cache is empty and will not update despite opening the sheet manually and waiting for it to fully load, entering a value in a cell and still nothing. Is there anyway to force the cache to update? Perhaps changing a cell, or doing something with the API or perhaps having a certain function in the cells that keeps the cache updated.
The text was updated successfully, but these errors were encountered:
I have a set of Google Sheets that use GoogleFinance, the sheets can take 10 seconds to fully load the data and update. Most update fine and I can access via the https://opensheet.elk.sh urls.
But sometimes the cache is empty and will not update despite opening the sheet manually and waiting for it to fully load, entering a value in a cell and still nothing. Is there anyway to force the cache to update? Perhaps changing a cell, or doing something with the API or perhaps having a certain function in the cells that keeps the cache updated.
The text was updated successfully, but these errors were encountered: