Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel

Status
Not open for further replies.

Excelprincess

Instructor
Sep 11, 2002
11
US
Is there a way to change the default in Excel, under options, for calculations? Example: Under options in Excel,I want "Manual" checked off and "Recalculate Before Save" DEselected. I would like this to be my default.
 
Excelprincess,

The options you speak of are options that, when set, become specific to the workbook in which they are set.

This, I would suggest, is "preferable" - to have this setting "specific" to each workbook.

This way, one is able to set the calculation to "manual" for LARGE workbooks, and to set it to "automatic" for smaller workbooks.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top