|
Excel Calculation Settings: Initial Calculation Mode
Note: Set Initial Calculation Mode is only available with FastExcel SpeedTools and FastExcel Manager Pro for Mac
You can use these settings to control which calculation mode Excel will use when opened.
.png)
|
By default the first workbook opened sets the mode until it is changed by the user
|
By default Excel sets the initial calculation mode from the first workbook opened, and does not automatically change it when another workbook with a different setting is opened.
FastExcel allows you to control the mode to be used when Excel first opens. This initial mode can be:
First Workbook (Excel default)
Manual
Manual with recalculate before save
Automatic
Automatic except tables
Limitation: When you use FastExcel initial calculation mode the empty workbook (Book1) that Excel creates when it is started will prompt you to save it when you close Excel.
|
|
Force Excel to open in Manual mode to prevent your workbook being accidentally recalculated when you open it
|
Excel Iteration
These settings control how Excel handles circular references.
.png)
Iteration
When checked Excel will attempt to resolve formulas that are linked by circular references by repeatedly calculating them.
Maximum iterations and Maximum change
Excel will stop the repeated calculation of the circular references as soon as either the maximum number of iterations has been reached or the maximum change in the values of all of the formulas is less that the specified maximum change.
Multi-threaded calculation Settings
.png)
Enable MTC
When Checked Excel (Windows Excel 2007 and Mac Excel version 16 and later) will split the calculation process over multiple threads. This will improve calculation speed on many problems, particularly with large workbooks and multiple recalculations.
Use all Processors/Manually Assign threads
You can control the maximum number of threads to be used by Multi-Threaded calculation
|
