FormulaMap
Somewhere in that inherited workbook, a formula multiplies by
a hardcoded 1.21. FormulaMap finds it — and every volatile
function, error cell and external link — in one scan.
€29 one-time · free tier, free forever · 30-day money-back
Every workbook you inherit is a minefield
The VAT rate is typed into twelve formulas instead of one cell. A stray
OFFSET makes the whole file recalculate on every keystroke.
Three #REF! errors hide on a sheet nobody opens, and a link to
a workbook on someone's old laptop quietly feeds your totals.
FormulaMap scans the lot and shows you a map. Hardcoded numbers inside formulas, volatile functions, error cells grouped by type, external links, full-column references — each with its location. Click a finding and Excel selects the cell. Pro adds a cross-sheet dependency overview and extracts your scattered constants into a proper Assumptions sheet, one click at a time.
Free vs Pro
Free finds everything risky. Pro maps how sheets feed each other and helps you fix the constants for good.
| Feature | Free | Pro €29 |
|---|---|---|
| Find hardcoded numbers inside formulas, with locations | ✓ | ✓ |
| Volatile functions (NOW, TODAY, OFFSET, INDIRECT, RAND) | ✓ | ✓ |
| Error cells grouped by type (#REF!, #DIV/0!, …) | ✓ | ✓ |
| External workbook links & full-column references | ✓ | ✓ |
| Click a finding to select the cell | ✓ | ✓ |
| Cross-sheet dependency overview (which sheets feed which) | — | ✓ |
| One-click extract of constants to an Assumptions sheet | — | ✓ |
| Export the audit report | — | ✓ |
How it works
Install the free add-in
Two minutes, no account, no card. Upload the manifest via Insert › Add-ins — see the install guide.
Scan the workbook
One click audits the used range and groups every finding. Click any item to jump to its cell. Free forever — not a trial.
Unlock Pro when you need it
Buy once on Gumroad, paste your license key into the pane. Dependency overview and constant extraction unlock instantly.
Installing FormulaMap
In Excel (Windows, Mac, or web): Insert › Add-ins ›
My Add-ins › Upload My Add-in, then select the FormulaMap
manifest.xml. A FormulaMap button appears on your ribbon.
Coming to AppSource: FormulaMap is being submitted to Microsoft's add-in marketplace, after which it installs in one click from inside Excel. Sideloading works today.
FAQ
Does it change my formulas?
The scan never touches anything — it only reads and reports. The one writing feature is Pro's constant extraction, which you trigger explicitly, constant by constant, and which puts values on a new Assumptions sheet and updates the formulas to reference them.
How big a workbook can it handle?
The scan is capped at 200,000 cells per pass so it stays fast and Excel stays responsive. Beyond that, FormulaMap tells you honestly and lets you scan sheet by sheet.
Does my spreadsheet leave Excel?
No. Formulas are read and analysed locally in your Excel session. No uploads, no analytics. See the privacy policy.
Refunds?
30-day money-back guarantee, no questions asked — reply to your Gumroad receipt or email [email protected].