Calculation Option

[Shay A]

Hello,
Any references to information regarding Automatic vs. Manual calculations would be much appreciated. Articles, posts etc. And for that matter, if my worksheet is on Manual mode, it will recalculate when I press F9 key?

Many Thanks,
Shay

 

[vletm]

Shay A
You can test to press Your F9 and You will see 'Calculate'-message.

Ps. My case ... it won't do so (photo below)

 

[AlanSidman]

if my worksheet is on Manual mode, it will recalculate when I press F9 key?

Yes. Usually, a spreadsheet is placed in manual mode if it is very large and has lots of formulas in it that are slowing down the input by calculating after each entry. If this is your case, place the SS in manual mode and press F9 before saving or printing.

 

[NARAYANK991]

Hi ,

This is from a Microsoft Excel MVP , and is the goto blog for this topic even for other Excel MVPs !

http://www.decisionmodels.com/calcsecretsc.htm

Narayan