AUTOMATIC CALCULATION RANDOMLY SWITCH TO MANUAL?

H

hilger2000

Why does the "automatic calculation" setting occasionally switch to manual
without me knowing? Excel 2003 did this, now 2007 is also.
 
G

Gord Dibben

Tools>Options>Calculation can be Auto or Manual.

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>


Gord Dibben MS Excel MVP
 

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

Calculation changing from Automatic to Manual 7
Calculation Manual vs Automatic 3
Excel 2003 automatic calculation all worksheets except one 3
How can I change the default manual calculation as automatic 5
Automatic/Manual Calculation 2
Dragging/Copying Formulas in Excel 2007 3
Calculation - Automatic and Manual 1
F9 Manual Recalculate only for one workbook 7

Top