Free Excel add-in: Workbook Statistics


We’ve recently released a couple of free add-in which should be of use/interest professionals who use Excel. 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:

  • A count of the number, text, logical and error constant (manually entered) cells in 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 dependencies (links) between workbooks (also shown as a diagram)
  • The report can be extended to display any statistic available within a workbook

You can find out more about Workbook Statistics on or download the add-in from our web site on on the Microsoft Development News (MSDN) blog for Excel.

Information and Links

Join the fray by commenting, tracking what others have to say, or linking to it from your blog.


Other Posts

Write a Comment

Take a moment to comment and tell us what you think. Some basic HTML is allowed for formatting.

Reader Comments

Be the first to leave a comment!