Thanks for your help, Harlan. I do use a Personal.xlsb so I reposted in the
Excel group.
Renny Bosch said:
Occasionally when I open an Excel file and enter some data I discover that
the option to automatically recalculate all formulas has been cleared. I am
talking about Excel Options | Formulas | Calculation Options | Workbook
Calculation | Automatic. Windows XP, SP 3, Excel 2007, SP1 MSO.
The file to which this happens contains a very large number of formulas,
including conditional formatting. Does that have anything to do with it?
Probably that does have something to do with it. Excel recalculation
settings are stored in workbooks rather than as application-level
settings, and Excel's recalculation setting is taken from the FIRST
workbook it opens. I'll assume you're not using a PERSONAL.XLS file,
so the first file you open varies from Excel session to Excel session.
When you open this particular workbook first (double clicking on it in
Explorer?), Excel takes its recalculation setting from this workbook,
and it was saved with recalculation set to manual.
The other possibility is that there's an autoopen macro in one of the
files you open that sets recalculation to manual. Set macro security
to medium (if it's not at that setting already) and open different
file. Not when Excel tells you that files contain macros, but ALWAYS
DISABLE them during this test. Once a file is open, check the
calculation setting, then close the file and move on to the next file.
You should see that Excel's calculation setting changes depending on
the file that's open.
In future ask Excel-specific questions in Excel-specific newsgroups.
This newsgroup isn't frequented by people who have detailed knowledge
about or experience using Excel.
