In Excel, the workbook calculation of formula is attached to each file, set by File -> Options -> Formulas -> Calculation options -> Workbook Calculation.
However, if Excel is opened directly, not by opening a file, a "Book1" will be opened and the setting is always "automatic". How could I make the default setting "manual"?
I found these instructions below:
Changing the default is done in the following way:
Create a new Excel document in which all default settings are set e.g. fonts, styles, logo, header, footer, ...
Save the file as book.xlt in the excel system startup folder
File > Save as
Browse to the Excel system startup folder
File name : book
Save as : Template (*.xlt)
Note:Excel searches the following directories to open all files in it when it is started
'User Excel Startup Folder'
c:\Documents and Settings\\Application Data\Microsoft\excel\xlstart
'System Excel Startup Folder'
c:\Program Files\Microsoft Office\office\xlstart
'Alternate Startup Folder'
However it seems it's talking about Windows NT. My OS is Windows 7.