Navigation: FXLV4Profiler >

Calculation Timing Commands

 

 

 

Calculation Timing Commands

There are seven FastExcel calculation timing commands.

These buttons calculate the selected items and optionally show you the elapsed time taken by the calculation.

Use FastExcel Calculation Control->FastExcel Settings to choose between the 2 available Range Calculate methods (with or without dependencies internal to the selected range) and the number of Range Calculate trials (default 3). Range Calculate then shows the median time of all the trials.

The currently selected cells, using Range Calculate. Alt-F9
If more than one Area is selected; each Area is calculated left-to-right and top-to-bottom, in the sequence that the areas were selected.
If more than one worksheet is selected then only the selected range on the active worksheet is calculated.
If one or more of the selected cells is part of a multi-cell array formula then all the cells in the array formula will be included in the calculation.
If Calculation is set to Automatic both the time taken to calculate the range in Manual mode and the workbook recalculation time are shown.

 

The currently selected sheet(s), using Sheet Recalculate. Shift-F9.
If more than one worksheet is selected all the selected worksheets are recalculated. If Calculation is set to Automatic both the time taken to recalculate the sheet(s) in Manual mode and the subsequent workbook recalculation time are shown. If MixMode sheets are selected by default they will be calculated

 

The currently selected sheet(s), using Sheet Full Calculate. Alt-Shift-F9.
If more than one worksheet is selected all the selected worksheets are recalculated. If Calculation is set to Automatic both the time taken to recalculate the sheet(s) in Manual mode and the subsequent workbook recalculation time are shown. If MixMode sheets are selected by default they will be calculated

All enabled sheets in open workbooks. Recalculate. F9.
MixMode sheets are not calculated unless Manual Calculation has been checked in MixMode options.

Calculate all open workbooks. Full Calculation. Ctrl-Alt-F9

Recalculate MixMode Sheets: All enabled sheets and any MixMode sheets in all open workbooks are recalculated. Ctrl-Shift-F9.

 

Select, run and time a macro.

 

To control the display of the calculation time, see FastExcel Calculation Control  -> FastExcel Settings.
There are keyboard shortcuts for these calculation commands.

 

Sheet Calculate re calculates the selected Sheets assuming that all precedent worksheets and linked workbooks have been correctly calculated.

Full Calculate Sheet calculates every formula on the selected Sheets assuming that all precedent worksheets and linked workbooks have been correctly calculated.

Recalculation is the default Excel calculation process. Only changed cells and formulas dependent on changed cells are calculated

Full calculation calculates all formulas in all open workbooks

Recalc MixMode Sheets recalculates all sheets including MixMode sheets.

 

 

 

 

 

 

Copyright © 2022 Decision Models Ltd.