Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Update after certain time period (60 sec)
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#5
|
|||
|
|||
You can read more about the scheduling procedures at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm mrdelia wrote: 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. -- Dave Peterson |
#6
|
|||
|
|||
Thanks to all the info helped solve my problem.
Darin "mrdelia" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculation for a givenn period | Excel Discussion (Misc queries) | |||
Auto Update / Save | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
auto update | Excel Worksheet Functions |