Navigation: FXLV4_Manager > Calculation Manager >

Excel Calculation Settings: Initial Calculation Mode

 

 

 

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.

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.

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

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

 

 

 

Copyright © 2020 Decision Models Ltd