Thank you,
I have tried OnTime with no success. It seems to update once and then stop.
How can I get it to return to the OnTime statement. I tried GoTo but locked
the spreadsheet up.
"Don Guillett" wrote:
Have a look in vba help index for
ontime
--
Don Guillett
SalesAid Software
"mrdelia" wrote in message
...
How can I set up a workbook to automatically update the data it retrieves
from other sources every 60 seconds. I can update manually by pressing F9
but
I would like it to be automatic.