22-May-2009 NEW UTILITY: Analyse A Workbook
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:
- The current file size, and what the file size would be without any formulae, charts or formatting
- Analysis of the amount of sheets, names, formulae etc...
- 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:
- To replicate the analysis, download and save both files
- Put FileName.xls directly on your C drive
- Press the button
- 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:
| Attachment | Size |
|---|---|
| FileName.xls | 40.5 KB |
| analyse-workbook.xls | 1.97 MB |
»
- Nick's blog
- Login or register to post comments
- 16744 reads
Update?
Hey Nick,
Love the concept of the tool, but it doesn't work properly with my excel sheet. Is there an update available? Thanks!
bugs
There are some bugs in this..
1. If worksheet are protected, unprotect them before running
2. Unhide all sheets
3. Close the workbook before running
Possible Enhancements:
1. Change to formulaR1C1
2. Sort by complexity
3. Add analysis for VBA
4. Add Formula Pivot
5. Format numbers with comma separator
Analyze this!
This is a great tool. I just ran it on mine and got a good idea on the number of Pivot tables and charts, along with formulae, names etc. The pivot tab which splits by worksheet comes in handy as well. THANKS! Laks