Finding Bottlenecks with FastExcel

Find the Problem Worksheets and Workbook Overhead

Note:Profile Workbook can take a long time to execute because the Workbook has to be recalculated several times

You can use the Profile Workbook command to find:

• The workbook calculation overhead.
• The calculation time and memory used for each worksheet.
• Used Range wasteage by worksheet.
• Worksheets with inefficient formulae.
• Worksheets with a sheet calculation overhead.

Find an improved worksheet calculation sequence

When you have a Workbook Calculation Overhead you can use the Optimise Worksheet Sequence command to:

• Find an improved worksheet calculation sequence.
• Find worksheet cross-reference loops.
• Map the forward worksheet cross-references.

Find the problem blocks of formulae on the worksheets

Use the Profile Worksheet Areas command to find the problem blocks of formulae on the Selected Worksheet(s).

• Select the worksheet(s) that take the majority of the time to calculate, or have a significant sheet overhead.
• The Profile Worksheet Areas command shows you the calculation time and formula length for each rectangular block and column of formulas on the sheet(s).

Find the problem formulae within a formula block

Use the Calculate Selected Range command to drill down to the calculation time for specific formulas within a problem block.