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.
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.
Another way to modify the Calculation Options is to select the File tab to move to Backstage View as shown in the image below.
Once in Backstage View, from the drop-down menu from the left we select the command Options as we can see below.
Once we select the command Options, the Excel Options dialog box appears as shown below, where from the left we select the category Formulas.
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.
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.
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.
This entry was posted in Word 365 ProPlus English and tagged Automatic, Automatic Except For Data Tables, backstage view, Calculate Now, Calculation Modes, Calculation Options, Cell Reference, Excel Options, Excel Workbook, F9, File, Formula, How To, How To Modify The Calculation Options in a Microsoft Excel Workbook?, Know How, Manual, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Word, My YouTube Channel, Office Smart, Office System, OfficeSmart, philippospan, Smart Office, smartoffice, Subscribe, Tip & Tricks.