How To Modify The Calculation Options in a Microsoft Excel Workbook?

Posted on

In Microsoft Excel, all the currently open Workbooks, use the same of Calculation no matter in which mode we have saved them. For to use different Calculation Modes, we must use different procedures to work with Workbooks that use different Calculation Modes. By default, the mode set to recalculate in an Excel Workbook is automatically. If we make any changes in a cell that is referenced in a Formula, Excel will automatically recalculate the Formula so that it returns a correct result based on the changes. Keep in mind, that if the Formula that it recalculates and is used as a Cell Reference in other Formulas, all the other Formulas that is dependent on the recalculated Formula will also be recalculated. To find out how to Modify the Calculation Options in an Excel Workbook just keep reading the post below.

How To Modify Calculation Options in Excel

We can either select the Formulas tab and from the right of the ribbon and the area named Calculation, we select the command Calculation Options as shown below. Once selected the drop-down menu appears and the options available are Automatic, Automatic Except For Data Tables and Manual. All three will be described below.

Calculation Options

Another way to modify the Calculation Options is to select the File tab to move to Backstage View as shown in the image below.

How To Modify Calculation Options in Excel

Once in Backstage View, from the drop-down menu from the left we select the command Options as we can see below.

How To Modify Calculation Options in Excel

Once we select the command Options, the Excel Options dialog box appears as shown below, where from the left we select the category Formulas.

How To Modify Calculation Options in Excel

Once the Formula category is selected from the left of the Excel Options dialog box, at the middle of the dialog box and at the top we notice the area named Calculation Options. The Calculation Options that we have available are the following and will be described.

How To Modify Calculation Options in Excel

  • Automatic: When we make any changes to the Workbook, all the parts affected of the Workbook will be recalculated.
  • Automatic Except For Data Tables: When we make any changes to the Workbook, all the parts affected in the Workbook will be recalculated except the parts of the Data Table. The Data Table will be recalculated only when we make a change in it.
  • Manual: When we make any changes to the Workbook, for all the parts affected in the Workbook to be recalculated we must either press the F9 button or select the Formulas tab and then from the right of the ribbon and from the area named Calculation we select the command Calculate Now as shown in the image below.
  • Recalculate Workbook Before Saving: We either activate or deactivate the command depending on what we want. If we keep it activated, the Calculation will occur every time we save the Workbook.

Calculate Now

Below you can check out the video describing How To Modify The Calculation Options in a Microsoft Excel Workbook?

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s