Automatic Re-calc

[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

 

[Gord Dibben]

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

 

[JohnR]

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?

YUP !

 

[Dave Peterson]

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.

 

[Gord Dibben]

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

 

[JohnR]

That solved it. THANK YOU !

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 Peterson]

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?

 

[Dave Peterson]

Was your personal.xls file hidden or visible?

That solved it. THANK YOU !

 

[JohnR]

Visible !

Was your personal.xls file hidden or visible?

 

[Dave Peterson]

Thanks for posting back.

Visible !

Was your personal.xls file hidden or visible?