Your files stay on your device

# XLSX formula inspector

List every formula in an Excel workbook by sheet and cell with its cached value, and flag errors, external links, volatile functions, and inconsistent formulas.

Drop an Excel workbook to inspect

.xlsx, .xlsm · Up to 60 MB · stays on your device
Older .xls and binary .xlsb workbooks need saving as .xlsx first. Password-protected files fail.Choose an Excel workbookor paste

Every formula is listed with the cached value Excel saved at its last save, sorted and filtered however you like. The audit flags cached errors such as #DIV/0!, references to other workbooks, volatile functions that recalculate on every edit, numeric constants other than 0 and 1 inside formulas, and formulas whose relative R1C1 form differs from two agreeing neighbours. Nothing is calculated, nothing runs: formulas show text, cached values show as stored, and a VBA project is detected, never opened. Formulas inside charts, conditional formatting, data validation, and pivot caches are not listed, and a formula that is consistently wrong passes the neighbour check. Workbooks written without cached values show blanks in that column.
Options

## More PDF & file tools

- [Excel sheets (XLSX)](/files/xlsx)
- [Word documents (DOCX)](/files/docx)
- [ZIP files](/files/zip)
[All PDF & file tools](/files)

Was this tool useful?
YesNo

---

Canonical HTML: https://nutter.tools/files/xlsx-formula-inspector
Markdown version: https://nutter.tools/files/xlsx-formula-inspector.md
Plain-text version: https://nutter.tools/files/xlsx-formula-inspector.txt
Agent index: https://nutter.tools/llms.txt