Trace and fix formula errors

Trace and fix formula errors in Microsoft Excel — with the four heights of help laid out: do it now, make it easier for the next person to accept, work out the right move when you are stuck, and learn the pattern so it stops coming back.

4prompt heights
Open it in the interactive atlas →

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

+
Several report cells show #REF! and managers are asking for corrected figures. Trace and fix…
Several report cells show #REF! and managers are asking for corrected figures. Trace and fix formula errors starting on the Summary tab: identify every cell returning an error, follow its precedents back to the first invalid reference, and repair each formula so it returns a meaningful value or a clear error message. Prioritize the Income Statement rows used in the board deck; leave a comment where you make changes.

Improve — make it easier to accept

+
Before I hand the fixed workbook back to the team, make the error fixes reviewer-friendly. For each…
Before I hand the fixed workbook back to the team, make the error fixes reviewer-friendly. For each repaired formula surface the original error and the cause, show the corrected formula, and add a one-line rationale for the chosen fix. Where you replace a deleted reference, suggest where the missing data should come from or a temporary hard value to use until the source is restored.

Decide — diagnose the stuck moment

+
I replaced a deleted-sheet reference in a reconciliation and that cell now calculates, but several…

I fixed one #REF! but others remain and I’m unsure why.

I replaced a deleted-sheet reference in a reconciliation and that cell now calculates, but several related cells still show #VALUE! and #N/A. I’m worried my single fix masked a deeper structural problem in the model. I don’t know which upstream formulas to trust. Which diagnostics will reveal whether errors are independent or come from the same broken source, and what’s the best next step to avoid making inconsistent repairs?

Become — change the pattern

+
Our models regularly produce errors after users insert rows or copy ranges, and we lose credibility…

We repeatedly ship models with fragile formulas that break when rows move.

Our models regularly produce errors after users insert rows or copy ranges, and we lose credibility in reviews. I want a sustainable habit to prevent fragile formulas and reduce incident tickets. Which design and review habits should the team adopt so formulas survive edits, and how do we make those habits stick across analysts?

Next to this one

Other spreadsheet work people do in Microsoft Excel.

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.

The rest of the map

Same library, five ways in.