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.

 

[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