Audit formulas in Excel with AI

Deckary's audit_formulas tool checks a specific Excel range for formula risks and structural inconsistencies. It reports findings; it does not silently rewrite the workbook. Use the findings to decide which cells need explanation, correction, or a separate visual dependency review.

What the audit detects#

The current audit can identify:

• Excel error results at individual cells;
• hardcoded numeric constants inside formulas;
• external workbook references;
• volatile functions;
• formulas whose relative pattern differs from neighboring formulas;
• rows that unexpectedly mix formulas and literal values.

Pattern checks use relative formula structure. That lets the audit distinguish an intentionally shifted formula copied across columns from a cell that breaks the surrounding pattern.

Run an audit#

Name the worksheet and a bounded range. The formula-audit tool accepts at most 20,000 cells in one request, so audit large workbooks by logical block rather than sending the entire used range without context.

Audit Model!F12:Q65. Prioritize formula errors, external references, and breaks
in copied formula patterns. Summarize findings by issue type and do not edit
the workbook until I review them.

The agent can inspect the returned cells and explain why a finding matters. If you then ask it to fix selected cells, that is a separate mutation with the normal overwrite and verification controls.

Formula audit versus Formula Tracer#

Use the AI formula audit when you want a range-level risk scan and a written explanation. Use the separate Formula Tracer when you want to navigate direct precedents and dependents visually in the workbook. One feature does not replace the other.

For broader workbook changes, see Use the AI agent in Excel.