Categories: Sheets :

ImportData how often does spreadsheet update?

Showing 1-3 of 3 messages
ImportData how often does spreadsheet update? dcummiskey 5/10/10 9:13 AM


I'm using Firefox and the newer version of Google Spreadsheets.Using ImportData, how often does this refresh? Or do we have to hit shift refresh to get the data to update?








2010-05-10
I'm using Firefox and the newer version of Google Spreadsheets.Using ImportData, how often does this refresh? Or do we have to hit shift refresh to get the data to update? Currently, the csv we use updates automatically every 20 minutes.
Re: ImportData how often does spreadsheet update? ahab 5/10/10 9:42 AM
About once every hour. The data is only refreshed on the server that buffers the data, so refreshing your spreadsheet won't help.

For a workaround method to overcome the delay see [1]

 
Re: ImportData how often does spreadsheet update? dcummiskey 5/10/10 10:08 AM
&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0) worked. thanks.