Find what’s broken in your spreadsheet. Fix it in one click.
Workbook Audit runs 31 checks on your file and flags what Excel won’t warn you about: broken formulas, hidden sheets, links to other workbooks, manual calculation, and your name in the file’s details.
Five issues found, each with its cell.
Showing the scan result.
31 checks, every upload
Each finding says why it matters and how to fix it in Excel. Most point to the exact cell, and clicking one opens the sheet with that cell marked.
- #REF!Formulas8
Formulas already returning an error, lookups stuck on #N/A, approximate matches that can return the wrong row, functions that show #NAME? in Excel 2016, and formulas too long or too nested to check by eye.
- ManualSettings3
A workbook left on manual calculation shows totals that never updated. Iterative calculation hides a circular reference instead of warning about it.
- RatesStructure6
Sheets, rows and columns a reviewer won't see, including very hidden sheets that Excel's Unhide list leaves out. Merged cells, protection, old array formulas and macros are listed too.
- TaxRateNames3
Named ranges pointing at cells that were deleted, names nothing uses any more, and names hidden from Name Manager.
- [Q3.xlsx]External and links2
Links to other workbooks that break when a file moves or gets renamed, and queries that pull data in from outside the file.
- C:\UsersPrivacy2
Your name, your company and folders on your own computer, saved in the file where whoever you send it to can read them.
- A:APerformance6
Why a file is slow or heavy: NOW() and INDIRECT() recalculating on every edit, years of piled-up conditional formatting, whole-column references inside SUMPRODUCT, the sheets that take up the space.
- “123”Data hygiene1
Numbers stored as text. SUM leaves them out and lookups miss them, with no error to tell you.
| Flag | Group | What it catches |
|---|---|---|
| #REF! | Formulas8 checks | Formulas already returning an error, lookups stuck on #N/A, approximate matches that can return the wrong row, functions that show #NAME? in Excel 2016, and formulas too long or too nested to check by eye. |
| Manual | Settings3 checks | A workbook left on manual calculation shows totals that never updated. Iterative calculation hides a circular reference instead of warning about it. |
| Rates | Structure6 checks | Sheets, rows and columns a reviewer won't see, including very hidden sheets that Excel's Unhide list leaves out. Merged cells, protection, old array formulas and macros are listed too. |
| TaxRate | Names3 checks | Named ranges pointing at cells that were deleted, names nothing uses any more, and names hidden from Name Manager. |
| [Q3.xlsx] | External and links2 checks | Links to other workbooks that break when a file moves or gets renamed, and queries that pull data in from outside the file. |
| C:\Users | Privacy2 checks | Your name, your company and folders on your own computer, saved in the file where whoever you send it to can read them. |
| A:A | Performance6 checks | Why a file is slow or heavy: NOW() and INDIRECT() recalculating on every edit, years of piled-up conditional formatting, whole-column references inside SUMPRODUCT, the sheets that take up the space. |
| “123” | Data hygiene1 check | Numbers stored as text. SUM leaves them out and lookups miss them, with no error to tell you. |
43 more tools. All free, no account needed.
No daily limit and nothing uploaded. Every tool runs in your browser.
Converters · into Excel
Viewers
XLSX Weekly
One Excel technique a week, worked all the way through, and new tools the day they ship. One click to leave.
Or start reading now: Articles · Cheatsheets