The following table explains the items that appear on the "Workbook" worksheet. All information relates to the active workbook at the time Summarizer was run.
|
Item
|
Details
|
| Report Run Time
|
date and time Summarizer was run
|
| Workbook Name
|
path and name of xls file
|
| Size (bytes)
|
xls file size (when the file was last saved)
|
| File Created
|
time at which xls file was first saved
|
| File Last Saved
|
time at which xls file was most recently saved
|
| Modified (since last saved)
|
"Yes" if workbook has been modified (or re-calculated) since it was opened; "No" otherwise
|
| Is Protected
|
either "Yes" or "No" depending on whether the workbook is protected
|
| Property
|
name of a built-in document property (see below) or a custom property name
|
| Value
|
value of corresponding property
|
Protection
If the active workbook or any of its worksheets are protected then Summarizer may not be able to access certain Excel information. In this case a warning in the form of yellow text box will be displayed on the output workbook. The text box will also be displayed if VBA code in the active workbook is protected.
Built-in Document Properties
Microsoft Office files have around 30 built-in properties such as Title, Subject, Author, Last Print Date and Number of Words. Excel only uses a handful of these properties. The remaining properties are available but not used (i.e. there is no corresponding value).
Although Summarizer shows all properties, some may have no value because they are unused by Excel.
