The following table explains the items that appear on the "Sheets" worksheet. All information relates to the active workbook at the time Summarizer was run.
|
Item
|
Details
|
| Sheet Name
|
name of sheet
|
| Type
|
either "Worksheet", "Excel4 Macro Sheet", "Excel4 International Macro Sheet", "Dialog Sheet" or "Chart"
|
| Is Visible
|
"Yes" if sheet is visible; "No" if sheet is hidden but accessible via Excel’s "Unhide" dialog box; "Hidden" otherwise
|
| Protection – Contents
|
"Yes" if contents are protected on a protected sheet; "No" if sheet is not protected (This entry will be blank for sheets that don’t support this type of protection.)
|
| Protection – Objects
|
"Yes" if objects are protected on a protected sheet; "No" if sheet is not protected (This entry will be blank for sheets that don’t support this type of protection.)
|
| Protection – Scenarios
|
"Yes" if scenarios are protected on a protected sheet; "No" if sheet is not protected (This entry will be blank for sheets that don’t support this type of protection.)
|
| Used Range
|
smallest range that encloses all non blank cells on a worksheet
|
| Cell Count – Non Blank
|
number of non blank cells on a worksheet (This entry will be blank for sheets that are not worksheets.)
|
| Cell Count – Formulas
|
number of formulas on a worksheet (This entry will be blank for sheets that are not worksheets.)
|
| Caption/Title
|
chart title or dialog sheet caption; blank for other types of sheet
|
