IBM Planning Analytics Tips & Tricks: Excel Workbook Stats

May 3, 2022

Have you ever wanted to know details about your existing worksheet or workbook such as the number of cells that contain data or the number of total sheets? In 2021, Microsoft Excel introduced a feature called Workbook Statistics that will provide details about your file.

The Workbook Statistics icon is found within the proofing area of the Review ribbon.

When the icon is clicked, a window appears to show details about the sheet. The following statistics are shown:

Worksheet level

End of sheet / Last cell
Number of Cells with Data
Number of Tables
Number of PivotTables
Number of Formulas
Number of Charts
Number of Images
Number of Form Controls
Number of Objects
Number of Comments
Number of Notes

Workbook level

Number of Sheets
Number of Cells with Data
Number of Tables
Number of PivotTables
Number of Formulas
Number of Charts
Number of External Connections
Number of Macros

Here is an example of a simple sheet that contains some input cells, some calculations, and a header row:

Not only will these details help you with generic Excel related questions, but the “end of sheet” and “cells with data” details can also assist when reviewing your dynamic reporting setups.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Author

Lee Lazarow

View all posts