Best Excel Formula Auditing Tools in 2026

Start with the Formula Auditing group already on the Formulas tab. Add a dedicated tool when you need a tree across sheets, a workbook report, or a comparison of two files. Elyx belongs in a different column: it explains and checks a formula you describe, and it does not replace a tracer.
What the Formula Auditing group is. Start the 7-day free trial, no credit card. Plus is €12/month and Pro is €29/month.
Spending too much time on Excel?
Elyx AI generates your formulas and automates your tasks in seconds.
Sign up →Summary
| Tool | Where it runs | Price |
|---|---|---|
| Excel Formula Auditing | Desktop Excel, Windows and Mac | Included with Excel. |
| Spreadsheet Inquire | Excel for Windows, certain editions | Included with those editions. Not sold separately. |
| RefTreeAnalyser | Excel add-in, Windows and Mac | Demo with limits. A license starts at €45. |
| Arixcel Explorer | Desktop Excel on Windows | Free trial, then a paid license. |
| Macabacus | Add-in for Excel, PowerPoint, and Word | Basic $200 per license per year. Professional $360. Enterprise is quoted. |
| Operis Analysis Kit (OAK) | Excel add-in | Paid license. Amount not published on the product page. |
| Spreadsheet Detective | Excel add-in | From the publisher list: AU$70, AU$125, or AU$225 per user per year. |
| PerfectXL | Excel add-in and separate review tools | Paid plans. Amounts are not on the pricing page. |
| Elyx | Inside Excel | 7-day trial, no card. Then Plus at €12/month or Pro at €29/month. |
| Microsoft Copilot in Excel | Inside Excel, with an eligible license | Included with an eligible Microsoft 365 or Copilot license. The amount depends on the plan. |
1. Excel Formula Auditing
- On the Formulas tab, the Formula Auditing group holds Trace Precedents, Trace Dependents, Remove Arrows, Show Formulas, Error Checking, Evaluate Formula, and Watch Window.
- Trace Precedents draws arrows to the cells a formula uses. A dashed arrow to a sheet icon means another sheet or another file. Evaluate Formula steps through one cell: each click on Evaluate replaces the underlined part with its value.
- The arrows are not saved in the file. Error Checking walks cells marked with a green triangle. Watch Window shows values from other sheets while you stay on the current one. None of these commands writes a report of the whole workbook.
2. Spreadsheet Inquire
- Microsoft says Spreadsheet Inquire is available only in Excel for Windows, in Microsoft 365 Apps for enterprise and equivalent editions. Turn it on under File, Options, Add-ins, COM Add-ins, then Inquire.
- The Inquire tab can run Workbook Analysis (structure, formulas, cells, ranges, and warnings), show relationships between workbooks, worksheets, and cells, compare two open files, and clean excess cell formatting.
- If Inquire is missing from the COM Add-ins list, that edition does not include it. Excel for the web does not include it. A workbook whose used range exceeds 100 million cells cannot be analyzed.
3. RefTreeAnalyser
- Jan Karel Pieterse publishes RefTreeAnalyser for tracing precedents and dependents across sheets, including charts, PivotTables, controls, data validation, and conditional formatting.
- The publisher page lists a license from €45 for 1 to 10 users: perpetual use on two computers and one year of updates. The download runs in demo mode. Demo tracing is limited to one level, and Report Errors lists up to 21 cells.
- Circular-reference detection is available in Excel for Windows and is not available on Mac. The reports flag items to review. They do not prove that the business logic is right.
4. Arixcel Explorer
- Arixcel Explorer opens the structure of a formula, traces precedents and dependents for several cells at once, colors formulas against hardcoded values, and compares workbooks.
- The publisher says it runs in desktop Excel on Windows and offers a free trial.
- The product homepage does not publish a price. Confirm the current license on the Arixcel site before you buy.
5. Macabacus
- Macabacus includes formula tracing (Trace In, Trace Out) and a formula view that highlights inconsistent formulas. Model checking is part of the same add-in.
- The pricing page lists Basic at $200 per license per year and Professional at $360 per license per year. Formula auditing tools are included in Basic. Enterprise pricing is requested, not listed.
- It is a broader Office add-in, not a formula-only product. Confirm the current platforms and the license on the Macabacus site.
6. Operis Analysis Kit (OAK)
- OAK is the Operis add-in for reviewing financial models: formula navigation, a workbook summary, a map of the sheet, and a comparison of versions.
- Operis describes it as a tool its modelling team built, then licensed. The product page does not publish a price.
- It is aimed at people who review large financial models. It is not the built-in Formula Auditing group, and it is not an agent you instruct in a sentence.
7. Spreadsheet Detective
- Southern Cross Software publishes Spreadsheet Detective for formula maps, precedent and dependent navigation, workbook reports, and comparison of two copies.
- The publisher price list gives Spreadsheet Auditor at AU$225 per user per year, Quantitative Analyst at AU$125, and a small-business license at AU$70. Charities are listed as free. Australian orders exclude GST.
- The site states support for Excel 2007 through Excel 2019, including Microsoft 365. Read the license type before you order: Auditor is the one that includes the question report for models built by someone else.
8. PerfectXL
- PerfectXL publishes a suite for spreadsheet risk: Risk Finder, Explore for dependencies, Compare for two versions, and Highlighter for inputs versus formulas.
- The pricing page names Professional, Medium Business, and Enterprise plans and does not publish the amounts.
- Use it when the task is a risk review of a model. It does not sit in the Formulas tab as a replacement for Trace Precedents.
9. Elyx
- You can ask Elyx to explain a formula, to check a range, or to rebuild a calculation in the open workbook.
- Elyx does not draw trace arrows, compare two workbook versions, or produce an Inquire-style analysis report. It is not a dedicated auditing suite.
- There is no permanent free plan. After 7 days the account is blocked until you subscribe. Elyx does not run in Google Sheets.
10. Microsoft Copilot in Excel
- On an eligible license, you can ask Copilot to explain a formula or to suggest one. Microsoft requires a qualifying Microsoft 365 or Copilot license.
- It is not Trace Precedents, and it does not write a workbook analysis report.
- The button is absent when the license or the organization does not include it.
Questions
What is an Excel formula auditing tool?
Software that shows where a formula gets its inputs, which cells use its result, or whether a workbook has inconsistent formulas. Excel already includes Trace Precedents, Trace Dependents, Evaluate Formula, Error Checking, and Watch Window.
Does Elyx replace Trace Precedents or Inquire?
No. Elyx is an AI agent inside Excel. You can ask it to explain a formula or to check a range. It does not draw precedent arrows, compare two files, or write an Inquire workbook report.
Where do you check a price this page does not state?
On the publisher page. Arixcel, Operis OAK, and PerfectXL do not publish an amount on the pages checked for this article, so the table does not invent one.
Start the 7-day free trial. Plus is €12/month and Pro is €29/month.
Reading Excel tutorials to save time?
What if an AI did the work for you?
Describe what you need, Elyx executes it in Excel.
Sign up