Does Excel recalculate everytime?

[ste mac]

Hi there,
I have a rather large workbook with lots and lots of formulae and
code (mostly from this NG) my question is:
When Excel starts up does it recalculate every formula etc on every
worksheet? would it be advantageous to place:
Application.Calculation = xlCalculationManual
and
Application.Calculation= xlCalculationAutomatic
at the begining and end of each macro in the workbook?

Thanks

seeya ste

 

[Frank Kabel]

Hi
if you have complicated macros these added line could speed-up your
macro execution time

 

[Will Riley]

You could do that,

Or you could set your calculation to manual under
Tools>Options. Pressing F9 will force a recalculation
whenever you desire.

Will

 

[Charles Williams]

Assuming that you are in Automatic calculation mode
(Tools-->Options-->Calculation) then when you open a workbook Excel will
generally only recalculate any formulae that contain volatile functions (NOW
OFFSET RAND etc), and any other formulae that depend on those formulae.

Yes its usually a good idea to turn off automatic calculation and
screenupdating at the start of each macro, then turn them on again at the
end.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

 

[ste mac]

Thanks for you help boys, much appreciated..

seeya ste