Workbook Statistics is a new feature Microsoft has released recently for Excel 365 users. Workbook Statistics is a dialog box that contains information about your spreadsheet such as the number of sheets, tables, formulas, charts, and PivotTables. In this guide, we’re going to show you how to get Workbook Statistics in Excel.
Workbook Statistics in Excel
First, please note that you need to have an Office 365 subscription to have access to this new feature. Office 365 is the subscription-based service for Microsoft Office. Microsoft presents latest and continuously updated versions of Office products and online services to subscribed users. For more information please see: What’s the difference between Microsoft 365 and Office 2019?
If you are an Office 365 user, you can find the Workbook Statistics icon under the Review tab of the Ribbon.
Clicking the icon displays the Workbook Statistics dialog with information of the active sheet and the entire workbook.
If you are not familiar with Excel Tables, in this context, you might find the “Table” item in the dialog window confusing. Table is not just any range that looks like a table in Excel. It’s actually a special structure to keep and organize data. To learn more about tables, please see: How to Create an Excel Table.
Want more? Meet the Inquiry Add-in!
For a more in-depth analysis of your files, you can use the Inquiry Add-in. This feature is included in the Professional Plus and Enterprise editions of Excel since version 2013. Thus, you can’t access the add-in if you have the Home version, even with an Office 365 subscription – sorry!
To begin, you need to enable the add-in, which is disabled by default. Follow the steps below to enable it.
- Click File > Options > Add-Ins.
- Select COM Add-ins in the Manage box, and click Go.
- In the COM Add-Ins dialog box, select the box next to Inquire.
- After the add-in is turned on, the Inquire tab will appear in Excel.
Click on the Workbook Analysis icon in the Report section to get workbook statistics for your Excel file.
If you want to keep the summary in a file, select the items you want to export, and use the Excel Export button to create an Excel file with the information you’ve selected.