|
Quick Start Calculation Profiling Reports
The Drill-down Wizard creates profile report sheets for:
The workbook and its worksheets (sorted by calculation time).
The formulas (sorted by calculation time) on the worst worksheets
Look for items that are highlighted in orange
The calculation profiler highlights in orange the potential problem areas you should look at.
You can see explanations of items by selecting a cell with a red triangle.
Worksheet potential problems
Unique Formulas: Orange if any formulas contain full column references
Conditional Formats Count: Orange if there are on average a large number of rules for each cell.
What-If Data tables: Always orange
Full Calc Time: Times are orange for sheets that are significantly above average
Sheet Volatile %: Orange if calculation is significantly volatile for this sheet
Used Range Waste: Orange if significant waste
Worksheet Formulas Profile potential problems
Formulas using a significant % of the worksheet calculation time are flagged orange.
Volatile functions, single-threaded functions and UDFs are flagged orange.
.png)
Volatility %
When your worksheets contain formulas with volatile functions (INDIRECT, OFFSET, RAND, NOW …) calculation will be slow any time you make a change to the workbook.
Multi-threading Efficiency
Excel’s calculation engine tries to share out the calculation load across the cores of your PC.
But some functions (INDIRECT, GETPIVOTDATA, most User Defined Functions etc.) are single-threaded and so block effective use of the cores on your PC.
|
