Profile Worksheet Areas

  Profile Worksheet Areas: Shows the Profile Header block, and profiles each rectangular block of formulas and, optionally, each column and each block of rows on each of the selected worksheets.

The Profile Worksheet Areas command shows you a form to allow you to choose between options.

Choose Profile Worksheet Areas Options

You can choose to profile one or more of:

The contiguous areas on the worksheet(s): either all or the selected areas.

The Worksheet Columns within the areas: choose the number of groups of columns you want – larger number gives finer granularity but takes longer.

The Worksheet Rows within the areas: choose the number of groups of rows you want – larger number gives finer granularity but takes longer.

You can also choose to show counts of formulas and formula lengths – but this uses more time.

The warning tolerance (Orange tolerance) controls the sensitivity of flagging the results as warnings. A larger number means more warnings.

Profile Selected Area

After reviewing the output from Profile Worksheet Areas you can select one or more of the problem areas on the worksheet that was profiled and use profile Selected Area to drill down into that area.

Worksheet Areas Profile Table

Cell counts of formulas, array cells and conditional formats.

Calculation times for the area, column and the sheet.

Total, average and maximum formula lengths.

Each table is sorted in descending calculation time sequence.

The first table profiles each separate contiguous rectangular area of formulas on the worksheet:

The second table profiles the columns: the number of column groups should be no more than the number specified in the options. The column groups are sorted in descending calculation time sequence.

The third table profiles the rows in the same way as the columns.

Copyright © 2022 Decision Models Ltd.