"Automatic Calculation" option intermittent
 

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. I do use a
Personal.XLSB file.

The file to which this happens contains a very large number of formulas,
including conditional formatting. Does that have anything to do with it?

"Automatic Calculation" option intermittent
 

More than likely you have some other file where the setting is manual.
If you open that file first and then open your book in the same session the
latest file will also adopt and retain the manual calc option.
Best solution?
Make sure that all your files are set to have automatic calc option.
if this is impossible you need to set the calc option each time you open
this file via a macro.

--
Greetings from New Zealand

"Renny Bosch" wrote in message
...
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. I do use
a Personal.XLSB file.

The file to which this happens contains a very large number of formulas,
including conditional formatting. Does that have anything to do with it?

"Automatic Calculation" option intermittent
 

Bill, doesn't the fact that I use a Personal.xlsb file ensure that that file
is always the first to be opened?

If I open an email attachment which is an Excel file, could that screw up my
setting?


"Bill Kuunders" wrote in message
...
More than likely you have some other file where the setting is manual.
If you open that file first and then open your book in the same session
the latest file will also adopt and retain the manual calc option.
Best solution?
Make sure that all your files are set to have automatic calc option.
if this is impossible you need to set the calc option each time you open
this file via a macro.

--
Greetings from New Zealand

"Renny Bosch" wrote in message
...
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. I do
use a Personal.XLSB file.

The file to which this happens contains a very large number of formulas,
including conditional formatting. Does that have anything to do with it?