What are the refresh features of the Google Spreadsheet Import features?
The imported information is not constantly approximately day with the resource web pages when I load the spread sheet. When this takes place, F5 refresh does not aid. Neither does Ctl - F5. Evidently there is some sort of caching taking place.
I'm assuming that they might be restricting the URL brings when I attempt to rejuvenate frequently - like when I'm proactively changing my spread sheet.
Doc reference: http://docs.google.com/support/bin/answer.py?answer=75507
As per this Google Docs Forum thread, the information need to rejuvenate concerning every hr
In that string, a poster recommends adding an arbitrary querystring to the URL you desire to scratch from -
I made use of a straightforward workaround of adding a parameter which updates every min.
Function call is: = ImportHtml (" http://www.fifa.com/worldcup/standings/index.html?" & H81" table" ;4)
Formula in H81 is: = Minute (Now ())
This suffices for me.