calculations

[hammer]

Problem: spreadsheet file of approximately 100 pages -
working with same file for years - just save under new
name. Formulas and calculations have always worked -
working with the file the week of Feb. 2 - 6, 2004 and no
problems - everything working just fine. Opened this file
on Feb. 10th and calculations went to a manual calc. I
went into Tools>options>calculations and found manual
selected. I never changed the file from automatic to
manual. I have another excel file that has macros that
request an enable each time I open the file but! I have
been in and out of that file for years also. Can anyone
solve this mystery; that all of a sudden my spreadsheets
went from an automatic calc to a manual calc? Also, I do
not receive outside email at my office.

 

[RWN]

Not an expert but;
I think one way this can happen is if you open a "Manual" calc WB 1st
then any thing opened subsequently will inherit that setting.
The same happens in the reverse as well, open an "Automatic" calc the
one that was manual and the setting will be automatic.

 

[Gord Dibben]

RWN

You are correct.

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 Excel MVP

 

[RWN]

Gee, it's nice to be right once in a while<G>.
Yes, it's more confusing than I can handle (and it has bitten me more
than once), that's why I always check!