Calculation - Manual vs Automatic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 automatic calculation all worksheets except one 3
Calculation - Automatic and Manual 1
Calculation changing from Automatic to Manual 7
AUTOMATIC CALCULATION RANDOMLY SWITCH TO MANUAL? 2
Automatic/Manual calculation question 1
Spreadsheet constantly reverts to manual calculation mode 3
Automatic/Manual Calculation 2
Calculation Manual vs Automatic 3

Back
Top