Automatic Re-calc

  • Thread starter Thread starter JohnR
  • Start date Start date
J

JohnR

I'm running Excel XP, and all of a sudden my workbook uses manual calc. I
go Tools --> options --> calculations and set it to Automatic. Next time I
open the workbook, its back to Manual
What am I doing wrong ???


Thanks
John
 
Calculation mode is set by the first workbook opened after a start up of Excel.

All subsequently opened workbooks will also take that mode.

1. Are you saving the workbook with auto-calc enabled?

2. Are you opening another workbook first?


Gord Dibben MS Excel MVP
 
Gord Dibben said:
Calculation mode is set by the first workbook opened after a start up of
Excel.

All subsequently opened workbooks will also take that mode.

1. Are you saving the workbook with auto-calc enabled?
Click to expand...

YUP !
 
Do you use personal.xls?

For most users, it opens as a hidden file.

You may want to open excel
use windows|Unhide to unhide that personal.xls window
change the calculation setting to automatic
use windows|Hide to hide personal.xls window
close excel and answer yes to the "want to save" prompt.
 
Dave

I experimented with this many times.

On my setup, Personal.xls when opening hidden does not set the calc mode for the
next workbook opened.

If I open it unhidden it does set the calc mode.


Gord
 
That solved it. THANK YOU !




Dave Peterson said:
Do you use personal.xls?

For most users, it opens as a hidden file.

You may want to open excel
use windows|Unhide to unhide that personal.xls window
change the calculation setting to automatic
use windows|Hide to hide personal.xls window
close excel and answer yes to the "want to save" prompt.
Click to expand...
 
I remember experimenting a while ago, and I thought that it did affect the calc
mode. But I could be wrong--I use a personal.xla file.

I wonder if the OP had his personal.xls hidden or visible?
 
Back
Top