FastExcel Settings
.png)
Calculation Timers for buttons and keys
You can control the FastExcel calculation time display separately for the calculate buttons and the calculate keys.
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.
|