How to Trace Precedents and Dependents in Excel
A total shows #REF! and you need to find which upstream cell broke it. Here's why Excel's tracing arrows make that harder than it should be — and the one-click way to map the whole chain.
Last updated: August 2026
| Broken total | Traced source | |
|---|---|---|
#REF! in G2 | → | Reads C5 (deleted range) |
| Formula in G2 | → | Precedents & dependents mapped |
Why the native arrows fall short
Excel does have Trace Precedents and Trace Dependents, but they draw blue arrows one cell at a time. Following a chain across a dozen formulas means clicking repeatedly, and the arrows pile up until the sheet is unreadable. There's no single view of how everything connects, so pinning a #REF! or #VALUE! back to the cell that started it is slow and easy to lose track of.
The 1-click way — Tellsheet's Formula Map
Run Formula Map to see how your formulas connect — each formula's precedents (what it reads) and dependents (what reads from it) — with error cells like #REF! and #VALUE! highlighted so you can trace a broken result straight to its source. It runs fully locally, so nothing leaves your PC. Pairs with Find All Errors and Explain Formula.
Frequently asked questions
How is this better than Trace Precedents?
The native arrows appear one cell at a time and clutter the sheet; Formula Map shows the connections across the range at once, in both directions.
Does it highlight error cells?
Yes — #REF!, #VALUE! and other errors are highlighted so you can trace a broken result back to its cause.
Does my workbook get uploaded?
No — it runs fully locally; your formulas are analysed on your PC.
Does it show dependents too?
Yes — both what a formula reads and what reads from it, so you see the whole chain.
Related Excel guides
Trace a broken result to its source
Formula Map connects your formulas — precedents, dependents, and highlighted errors — fully on your PC.
Get Tellsheet free See pricing