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.

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

thanks dave