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

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.

How do you make the auto calculate setting stay on manualpermanently?
 

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 wrote:

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

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

thanks dave