Joined: 12 Jan 2009
Location: Florianopolis - Brazil
|Posted: Thu May 20, 2010 6:28 am Post subject: Timering "Sheet from File" refreshing
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)?
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.