Understand a pivot table, in plain words
You inherit a workbook with a pivot table, and you want to know where it gets its figures and what it computes, without clicking all over Excel. The tool reads its definition and turns it into sentences.
What this tool does
- The source: the sheet and range, or the table, the data comes from.
- The fields in rows and columns, and the filters applied.
- The values and their calculation: sum, average, count, and percentages of the total.
- Every pivot table in the workbook, on its sheet and cell.
- Nothing is sent or recomputed: it reads the definition, as Excel saved it.
What it does not do: The tool reads what a pivot table is set to do, it does not run it or show its computed results. A calculated field written by hand is named, without being detailed.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.
- Clean before sending : Author, comments, hidden sheets, macros: what travels with the file without showing.
- Inspect a workbook : Hidden sheets, author, comments, links: what the file carries without showing it.
- Formula audit : Errors, hard-coded values, formulas that stand out: what to check in a model.
- Dependency map : Which sheet reads which, which workbooks are called: the workbook's diagram.