Calculation

[dhstein]

I check the status of recalculation at the beginning of macros and then turn
it off for faster processing. At the end I set it back to whatever it was
(Automatic or Manual). During the macro execution I sometimes recalculate a
sheet. At the end when I turn it back on, there is no need to recalculate
since I've done whatever calculations are needed. Is it possible to prevent
Excel from recalculating when I set Application.Calculation = xlAutomatic ?
Thanks for any help on this.

 

[Simon Lloyd]

I check the status of recalculation at the beginning of macros and then
turn
it off for faster processing. At the end I set it back to whatever it
was
(Automatic or Manual). During the macro execution I sometimes
recalculate a
sheet. At the end when I turn it back on, there is no need to
recalculate
since I've done whatever calculations are needed. Is it possible to
prevent
Excel from recalculating when I set Application.Calculation =
xlAutomatic ?
Thanks for any help on this.Just turn calculation back on in your before_close macro after all the

other tasks have taken place.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Charles Williams]

Doing a Sheet.Calculate flags the workbook as dirty, so that the next time
you get to Automatic Calculation Excel will calculate all open workbooks.

The only way to avoid this is to use Application.Calculate rather than
Sheet.Calculate or Range.Calculate.

If your Automatic recalc is taking a long time you could think about how to
reduce workbook volatility, and how to speed up your calculations.

regards
Charles Williams
Decision Models