Auto Calculation Setting

[Guest]

The setting for auto calculation on one of our computers resets its self to
manual. This has happened twice now. Is there some type of bug with excel
or is there something that needs to be done to save the setting. It is under
TOOLS-OPTIONS-CALCULATION (tab).

Thanks
CJ

 

[Guest]

If you open a spreadsheet where the calculation is set to manual - it will
then change to manual for all spreadsheets you have open.

 

[Chip Pearson]

The calculation mode is set by the first workbook that is opened.
Therefore, if you have a personal.xls workbook (or any other
workbook in the XLStart folder) that has manual calculation, your
calculation mode will get set to manual.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message
news:[email protected]...