| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timed Automatic Refresh of Cells
Hi, I have a number of calculations in a sheet. These use
addin formula to get data from an external system. I use the F9 key to get the formula to update the values, but I was wondering if there is any easy way to get excel to recalculate the sheet automatically at a given timed interval, say or 10 seconds ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Timed Automatic Refresh of Cells
You can use the OnTime Function
there is an excellent example at http://cpearson.com/excel/ontime.htm -----Original Message----- Hi, I have a number of calculations in a sheet. These use addin formula to get data from an external system. I use the F9 key to get the formula to update the values, but I was wondering if there is any easy way to get excel to recalculate the sheet automatically at a given timed interval, say or 10 seconds ? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Automatic Refresh | Excel Discussion (Misc queries) | |||
| 'Enable Automatic Refresh?' | Setting up and Configuration of Excel | |||
| enable automatic refresh | Excel Worksheet Functions | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Linear Mode
