There are many reasons why you would want to turn of automatic calculation in Excel. One reason I often meet is when my spreadsheet uses randomly generated numbers or if I have huge spreadsheets which take some times every time it refreshes its calculations.
To turn off go to 'File', then 'Options'. Select the 'Formulas' tab and under 'Calculation options' you will find three options:
- Automatic
- Automatic except for data tables
- Manual
Under manual you can select 'Recalculate workbook before saving'. Use this if you want Excel to refresh all values before saving your workbook.
When 'Manual' is selected you can refresh either with the 'F9' key or by clicking 'Calculate Now' under the 'Formulas' tab.
No comments:
Post a Comment