Calculation error

[Guest]

I am working on a very large spreadsheet with complex formulas and after it calculates, the word "calculation" appears in the message bar at the bottom of my screen. What does this mean? Is this an error message?

 

[Frank Kabel]

Hi
this indicates that your spreadsheet is too complex to further enable
automatic calculation. You're now in the manual calculation mode. To
re-calculate hit F9

 

[Charles Williams]

Hi Donna,

Actually your spreadsheet will still calculate automatically.

Also there is more than one condition that can cause this: see
http://www.decisionModels.com/calcsecretsf.htm for details of the possible
causes and how to find out which one you have got!


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