naoliva
Power User
Joined: 12 Jan 2009
Posts: 65
Location: Florianopolis - Brazil
|
 Posted: Thu May 20, 2010 6:28 am Post subject: Timering "Sheet from File" refreshing |
 |
|
Hi there,
Does someone know how could I force a sheet imported from and linked to an external file (using command Insert > Sheet From File) to be automatically updated (not only when opening the spreadsheet, but every xx seconds)?
URL: http://download.finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr
The other possible command 'Link to External Data' which allow us to set an updating time does not work in this case... the file is recognized/found, you can decide the layout of the source for importation, but no single table/range is put available for selection.
I believe at least a simple macro could do that.
Tks. |
|
