Formula Trace: see exactly how any formula works
Select any formula cell in the Excel add-in and open Formula Trace — every input is color-coded, clickable, and shown with its live value, next to a plain-English explanation of what the formula actually does. Lookups show the exact row they matched, and you can ask follow-up questions right in the panel.
- NewTrace any formula: every input color-highlighted on the sheet, clickable, with live values
- NewA plain-English explanation of each formula, and an Ask box for follow-up questions
- NewVLOOKUP and INDEX+MATCH show exactly which row they matched and what they returned
- NewAudit flags catch hardcoded numbers, blank inputs, and cross-sheet links — and walk an error back to its source
- NewDrill into nested formulas in place, or follow them level by level
- ImprovedThe trace stays live — edit an input and the panel refreshes in place
- NewSign in to the add-in through your web browser with a one-time code
- FixedVery large data imports could occasionally land in the sheet as a single corrupted row