Peter,

If you open more than one workbook simultaneously, you can't. The first workbook's
Auto/Manual setting applies to all subsequently opened workbooks, and if any is saved, that
setting is saved with it. It's a serious problem. They plan to fix this in 2057.

You could put some code in the Workbook_Open routine to set it to manual, if you're willing
to do macro stuff, and macros have to be enabled.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"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