Workbook statistics add-in
Sometimes it is helpful to be able to report statistics about the set of workbooks contained in folder. This add-in provides such a report and includes (see the screenshot below):
- A list of the sheets in a workbook and note of their status (active, hidden, etc.)
- A count of the number, text, logical and error values (manually entered) in cells on each sheet;
- A count of the number, text, logical and error formulas in each sheet;
- The number of names defined on each sheet and at the workbook level;
- The number of external references.
The add-in is "unlocked" which means you can extend the functionality to more precisely meet your needs.
Signup to download and install the add-in you can access using the link at the top of the page. You will be prompted to sign up (or sign in if you already have an account on this site).
Copyright (c) 2008-2011 Lyquidity Solutions Limited
The Lesser GPL license allows you to use the software for any purpose, including the options to use, copy, modify, merge, publish, distribute, sublicense, and/or sell, but requires that if you create a derived work (anything based on this original) this original source is made available with your derived work and that this license, and original copyright marks, are included with the derived work.
Using the add-in
- How long will it take
Examples & Screenshots
The addin will include a section in the report for each sheet of every workbook in the folder hierarchy you choose. Statistics are generated for each sheet and aggregated to create workbook summary statistics.
The diagram is generated using a simplified Sugiyama-like layout algorithm and drawn using Excel shapes and connectors.
Green nodes indicate spreadsheets containing links within the set of spreadsheet being reviewed. Yellow nodes represent spreadsheets that are referenced but do not contain links. Red nodes are references to spreadsheets outside the range of documents covered by the report.