Calculation - Manual vs Automatic

[Daniel Bonallack]

I don't fully understand how Excel's manual vs automatic setting works. We
work with large formula-intensive spreadsheets, and NEVER want the setting to
be automatic.

What I have figured out is that if I crash, the setting resets to automatic.
And, if I save a spreadsheet with Manual setting, it stays Manual next time
I open it, unless Excel is already open with Calc = automatic. Is this right?

But my key question: Is there any way to ensure that Excel remains
calculation=manual at all times when a file is opened? If nothing else, can
we add a piece of code to our template file that changes the setting as it is
opened?

Thanks in advance
Daniel

 

[Ken Wright]

Excel takes it's calculation state from that of the first workbook opened in
that session. If that workbook happens to be your personal.xls or a timecard or
something else that was saved in automatic mode then Excel will switch to
automatic. Try opening your personal.xls, making it manual, saving it and
closing it.