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

0
2019-05-18 21:47:26
Source Share
Answers: 1

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.

0
2019-05-21 05:44:45
Source