Check Active Workbook
This command produces a report showing statistics for the active workbook.
Potential problem areas are highlighted in Orange.
![](images/image(184).png)
Common problem areas that need clean-up are:
Large number of styles.
Large number of Temp Files
Large amount of wastage: used range problem
Large number of Defined Names.
Most of the statistics have cell comments indicated by a red triangle marker in the top left of the cell explaining what the numbers represent. When you hover your mouse over the cell with the red market the comment pops up.
![](images/image(185).png)
Some statistics are not available for Mac Excel.
|