Workbook Calculation Settings

Navigation: FXLV4Profiler > Calculation Manager >

Workbook Calculation Settings: Workbook Options

Restore Workbook Calculation Mode after open

This option is only available with FastExcel V4 SpeedTools and FastExcel Manager Pro for Mac

Force Full Calculation

This option is only available in Excel 2007 and Mac Excel Version 16 or later.

If checked every calculation on this workbook will be a full calculation rather than a recalculation, and the time taken to rebuild the dependency trees will not be needed at workbook open time or when the workbook is edited.

Switch on Force Full Calculation if adding a row at the top of a worksheet is very slow and Full Calculate time is close to Recalculate time.

Update Remote References

If TRUE automatically update any remote references (DDE Links to other programs) whenever Excel recalculates.

Save External Link Values

If TRUE Excel will save values for the links to external workbooks. I recommend keeping this option as TRUE

Precision as Displayed

Checking this box will force Excel to calculate to the number of decimal places that appear as a result of your formatting, and will permanently change any numbers stored in cells.
You need to be sure you have thought through the full implications of this before using it.
Precision as Displayed slows down calculation.

1904 Date System

If TRUE changes the starting date from which all dates are calculated from January 1 1900 to January 2 1904.

Accept Labels in Formulas

This allows Excel to use natural language labels in formulas. Because there are circumstances when this will give you unexpected or ambiguous results, I recommend you do NOT use this feature.