Today’s contributor is Sarah Hothersall,
Office 2007 Professional Plus, Liaison Director at Lyquidity. She’s providing information about the Workbook Statistics add-in, a free tool for Excel users that was created by Sandy Marshall, a Product Manager at Lyquidity, who is in charge of development of ComplyXL for enterprise spreadsheet management. To download this add-in,
Windows 7 64 Bit, visit Sometimes it is helpful to report statistics about a set of workbooks contained in a folder. You can use this add-in to create such a report. The report it provides includes the following statistics: A count of the number,
Windows 7 Home Premium, text,
Windows 7 Starter Key, logical and error constant (manually entered) cells in each sheet A count of the number,
Windows 7 Discount, 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 report can be extended to display any statistic available within a workbook. The report also displays a dependency diagram that is generated by the add-in to document all worksheet relationships it discovers and to highlight links to workbooks in other folders.