Rank every ZIP part by size
See which sheets, images, pivot caches, and styles make a workbook large.
Workbook audit tools
Each tool is a focused view of the same local engine. Drop a workbook on the one that matches the question you have, or start on the home page if you want the audit score and every finding together. Nothing you drop is uploaded.
Size and bloat
Find the parts, ranges, caches, and rules that make a workbook heavy.
Declared range versus last real cell
Compare each sheet’s declared used range with the last cell that holds a value.
Pivot cache size and saveData
Measure pivot cache records, saveData, and refreshOnLoad without opening Excel.
Rule counts and sqref fragmentation
Count conditional formatting rules and fragmented ranges that bloat styles.
Speed and formulas
See volatile functions, cached errors, names, and formatting that slow calculation.
Volatile calls and whole-column references
Count NOW, TODAY, RAND, OFFSET, INDIRECT, and whole-column refs.
Error values stored in the workbook
List cached #REF!, #VALUE!, and #N/A cells with sheet addresses.
Hidden, broken, and unused names
Review hidden, broken, external, and unused defined names.
Risk and exposure
Inventory macros, hidden sheets, and links to other files before you trust a workbook.
External targets and formula hits
List workbook links and the formulas that still use them.
VBA modules and auto-start names
See whether a workbook contains VBA, which modules it lists, and auto-start names.
Visible, hidden, and very hidden
List visible, hidden, and very hidden sheets from the workbook part.
Package integrity
Check whether the ZIP package and its XML parts are complete and well formed.
ZIP parts and XML well-formedness
Test ZIP integrity, missing parts, and XML well-formedness.