Create a spreadsheet called Book1.xls. Set the calculation mode to manual,
then save the spreadsheet in C:\Program Files\Microsoft
Office\Office11\XLSTART. I'm assuming you are using Excel 2003. If not, then
the Office11 folder may be Office, or Office10. Each time you start Excel, it
will use the Book1 template and the calculation mode will be set to manual.

"Peter" wrote:

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