How do you make the auto calculate setting stay on manual permanently?

[anasttin]

Hi,

I have a spreadsheet that I want to be always set on manual calculation
(ie. you hit F9 whenever you want it to recalculate).

I change the setting and save the file but when I reopen it, it's back
on auto calculate.

Any help would be much appreciated.

Thanks.

 

[Dave Peterson]

Excel picks up this setting from the first workbook you open in that session.

Maybe your first workbook is personal.xls and it's set for manual calculation?

 

[anasttin]

thanks dave