Today’s contributor is Sarah Hothersall,
Office 2010 License, 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,
Office 2007, who is in charge of development of ComplyXL for enterprise spreadsheet management. To download this add-in,
Office Professional Plus 2010 Key, 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,
Microsoft Office 2010 Home And Business, text, logical and error constant (manually entered) cells in each sheet A count of the number,
Office 2007 Pro Plus Key, 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. <div