By default, Excel calculates all formulas instantaneously when they are entered in a worksheet. You can, however, change the calculation options so that formulas will only calculate when directed by you. If you have large sheets of data and multiple formulas trying to calculate at once, it can take a while for all the calculations to update. If that’s the case, you’ll want to update this setting.
Change the Formula Calculation Options
- Click the Formulas tab.
- Click the Calculation Options button.
Three options appear in the menu:
- Automatic: This is selected by default. Values are automatically recalculated whenever a change occurs.
- Automatic Except for Data Tables: The workbook is automatically updated with any changes. Data tables are only updated manually.
- Manual: The workbook is only updated when directed by the user.
- Select a calculation option.
- Update the worksheet.
There are two ways to manually calculate the sheet. The Calculate Now button calculates the entire workbook, while the Calculate Sheet button only calculates the current worksheet.
- Click either the Calculate Now or Calculate Sheet button.
Pressing F9 or saving the workbook also recalculates the workbook.
The workbook or worksheet recalculates.
FREE Quick ReferenceClick to Download
Free to distribute with our compliments; we hope you will consider our paid training.
- Excel Consolidate
- Goal Seek in Excel
- Scenario Manager in Excel