Quick Start Calculation Profiling: Drill Down

Navigation: FXLV4Profiler >

If you would like to get some immediate profiling results on your workbooks without delving into lots of details you can simply use the Drill-down Profiler Wizard to find the Calculation Bottlenecks.
Once you are more familiar with some of FastExcel's features you can use the online help and FastExcel manuals to investigate additional ways of finding and eliminating bottlenecks.

Click Drill-down to Profile the active Workbook and up to 5 of the slowest worksheets: Note that the Trial Version only profiles a single worksheet

Find the problem worksheets, volatility and multi-threading inefficiencies

When you click the Drill-down wizard button it first profiles the active workbook to find and prioritize:

The calculation times for each worksheet.

Workbook and worksheet Volatility and multi-threaded efficiency

Used Range wastage by worksheet.

Find the worst formulas on the 5 worst sheets

Then the Drill-down wizard will automatically drill down step-by-step to profile the formulas on the worst 5 worksheets that contribute > 5% of the total calculation time. For each unique formula on each sheet you will see:

% Contribution to total sheet calculation time

Total and average calculation time

Count and address of the formula

Flags for CSE array formulas, Volatile, single-threaded formulas and formulas using UDFs.