How Excel Determines Calculation Mode

Excel sets the initial calculation mode from the first workbook opened or created.
Excel templates and add-ins are excluded from this rule. Add-ins cannot alter the Calculation mode, unless at least one workbook is open when the Addin is loaded or run.
All subsequently opened Excel workbooks use the same mode of calculation as the first opened workbook, regardless of the mode in which they have been saved. Their calculation mode is simply being ignored.

How To Add Calculations Options In QAT

Any command, including Calculation Options, can be added to the Quick Access Toolbar (QAT) for faster use.

QAT is a customizable toolbar that contains a set of commands that are independent of the tab that is currently displayed.

To add Calculation Options (or any Calculation related command) to QAT:

Right click anywhere on the Ribbon or Quick Access Toolbar or go to File > Options
Select Customize Quick Access Toolbar
Click 'Choose commands from' and select 'All Commands' to get an alphabetical listing of ALL available commands
Scroll down and select 'Calculation Options' command and click the Add>> button
Note that when you click Add>>, the command is added below the selected command on the right side of the dialog. So to add a command in a particular position, first select the command above where you want to insert it. Alternatively, you can use the Up and Down arrows to re-position a command on the QAT
Click OK

You now have a convenient a command on your QAT that will give you easy access to Calculation Options.

How show calculation options in QAT

Please note:

The size of QAT command buttons cannot be increased
The Quick Access Toolbar cannot be displayed on multiple lines
Only commands can be added to the Quick Access Toolbar. The contents of most lists, such as indent and spacing values and individual styles, which also appear on the Ribbon, cannot be added to the Quick Access Toolbar

The Quick Access Toolbar can be positioned in any of these two locations:

Upper-left corner, above the File tab
Immediately below the ribbon

QAT shown above Excel's ribbon

How to move the QAT below the ribbon (above the grid)

QAT shown below Excel's ribbon (above the grid)

comments powered by Disqus

Home » Tutorials » How Excel determines Calculation Mode