Disclosure: this post was drafted with AI assistance and checked against the live product page. I build BeginThings, which makes the add-in mentioned near the end.

Someone hands you a 12-sheet forecast and asks, "Can you update the Q3 numbers?" The summary tab says gross margin is 62.5%. Before you touch anything, you need to know one thing: what actually feeds that cell?

Here is the workflow I use, first with plain Excel, then with an add-in when the model is too big to do by hand.

1. Start from the output, not the inputs

Pick the one result people care about (margin, cash at month 12, total cost) and work backwards. Reading a model top-to-bottom wastes time on cells that don't matter to the question you were asked.

2. Use Excel's built-in auditing tools

All of these live under Formulas → Formula Auditing:

  • Trace Precedents draws arrows to the cells a formula uses. Click it again to go one level further back. A dashed arrow with a small sheet icon means the input sits on another sheet; double-click the arrow to jump.
  • Ctrl + [ selects the direct precedents of the active cell. Ctrl + Shift + { selects all precedents on the same sheet.
  • Evaluate Formula steps through a long formula one part at a time, so you can see which piece produces the odd value.
  • Watch Window keeps the output cell visible while you edit inputs on other sheets.

3. Hunt for numbers typed into formulas

The most common hidden risk in an inherited model is a constant buried inside a formula, like =E2*0.18 instead of =E2*Assumptions!B9. When the tax rate changes, someone updates the Assumptions sheet and that cell silently stays at 18%.

By hand, you can use Home → Find & Select → Go To Special → Constants to find typed values, but that only finds cells that are pure constants, not numbers sitting inside formulas. For those you end up reading formulas one by one (Ctrl + ` shows formulas instead of results).

4. Write down what you checked

Whatever you find, leave a note on the cell (Review → New Note) saying what you checked and what is still open. The next person (often you, three months later) will thank you.

Where this breaks down

The built-in tools work well on one sheet. They get painful when:

  • the result depends on cells across many sheets, and the arrows become a tangle;
  • you need a map of how the sheets connect before you know where to start;
  • you want a list of every hard-coded number and broken link, not just the ones you happen to click.

Doing the same thing with Formula Mapper

We built Formula Mapper, an Excel add-in, for exactly this "inherited workbook" job. What it does, per the product page:

  • Formula Review: select a result and it shows every cell that feeds it in a tree you can walk, with click-through to the referenced sheet and a plain-English line explaining the calculation (for example: "This formula rounds (BD7 multiplied by Assumptions!BD9) to a whole number").
  • Sheet Map: lays out the workbook's sheets and the links between them, so you can see where to start.
  • Findings list: lists numbers typed straight into formulas (like that *0.18), together with inconsistent formulas and broken links; open a finding to go to the cell.
  • Review notes: attach notes to specific cells, keep a review list and produce a report you can share, all kept with the workbook.

It needs Excel for Microsoft 365 on Windows (64-bit). You create a free BeginThings account and download the add-in; the 11-day free trial starts when you first sign in inside Excel with that account. The trial needs no card and doesn't create a subscription or charge you.

There's also a small in-browser demo on the page (an illustrative sales model, not the add-in itself) where you can change units, price and cost and see what each cell feeds:
https://beginthings.com/formula-mapper.html?utm_source=devto&utm_medium=community&utm_campaign=cm-formula-mapper-trace

Checklist

  1. Pick the output that matters.
  2. Trace Precedents / Ctrl + [ back to the inputs.
  3. Check cross-sheet arrows.
  4. Look for numbers inside formulas.
  5. Leave a note on everything you checked.