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

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