Periodic Calculating

[Guest]

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.

 

[Guest]

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