Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Periodic Calculating
Hi,
I have a Excel model that have a lot of Calculations in it. It is updated continously by an livefeed from the fx market, and excel is calculating all the time. Is it possible to set the calculations so it automatically calculates every 1 minute (or whatever i want), in addition to the possibility to take a manual calculation (F9), when neede. -- Peter B Norway |
#2
|
|||
|
|||
Hi Peter
you could set the calculation mode to manual and use the OnTime method to force a calculation every minute. See: http://cpearson.com/excel/ontime.htm "Peter B" wrote: Hi, I have a Excel model that have a lot of Calculations in it. It is updated continously by an livefeed from the fx market, and excel is calculating all the time. Is it possible to set the calculations so it automatically calculates every 1 minute (or whatever i want), in addition to the possibility to take a manual calculation (F9), when neede. -- Peter B Norway |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate CAGR when there are periodic additional investm | Excel Worksheet Functions | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Calculating due date? | Excel Worksheet Functions | |||
Calculating due date? | Excel Worksheet Functions | |||
calculating weeks worked | Excel Worksheet Functions |