This utility is aimed at working out how complex a spreadsheet is

• Simply enter the full file path of the file, press the button, and you will be provided with an analysis of your file.

You'll get:

1. The current file size, and what the file size would be without any formulae, charts or formatting
2. Analysis of the amount of sheets, names, formulae etc...
3. File attributes

The content of the cells categorised in a data table:

A pivot table that you can play with to provide whatever analysis you're after:

Instructions:

1. To replicate the analysis, download and save both files
2. Put FileName.xls directly on your C drive
3. Press the button
4. To run your own file, enter the file path next to "Workbook to analyse", and run the analysis.

Download sheet to practise how to Analyse A Workbook in Excel

Training Video on how to Analyse A Workbook in Excel: