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. **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.
- Click either the
**Calculate Now**or**Calculate Sheet**button. - Click
**OK**.

Three options appear in the menu:

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.

Pressing **F9 ** or saving the workbook also recalculates the workbook.

The workbook or worksheet recalculates.