If you save a *.xlt file in this location "C:\Documents and
Settings\%userid%\Application Data\Microsoft\Excel\XLSTART" Excel will start
with the last saved WB.

"Bill Kuunders" wrote:

I believe auto calc setting depends on the option in the last open workbook.
so, if you have more than one book open at the same time..............

--
Greetings from New Zealand

"Peter" wrote in message
...
I know you can turn off a spreadsheets auto calculate function by
ToolOptionsCalculationManual. However even after I saved the workbook
with this setting, when open it again, is reset itself to autocalc. How
can I
switch off auto calc so it stays off.
Many thanks
--
Peter
London, UK