|
FastExcel Settings
.png)
Calculation Timers for buttons and keys
You can control the FastExcel calculation time display for the calculate buttons.
When checked you will see a message box after the calculation showing the time taken by the calculation.
Range Calculate Settings
.png)
Range Calc including or excluding Dependents
In Excel 2007 and later there are 2 different Range calculate methods. One includes within-range dependency calculations and the other ignores within-range dependencies and calculates row by row strictly left-to-right and top-to-bottom. Range Calculate always ignores dependencies outside the selected range, although the selected range will be expanded to include all the cells in multi-cell array formulas.
Set Number of RangeCalc Trials
Because RangeCalc timing can be sensitive to Windows multi-tasking it is better to allow a number of trials. The Median (middle-most) calculation time will automatically be used, thus discarding incorrectly high and low values.
You can set the number of trials: the default number is 3.
Include Screen Refresh Time
If checked timings for Range Calculate will include the time used by Excel to refresh the visible window.
|
