Workbook Comparison · Ribbon group: Compare
Know why outputs moved.
Compare workbook versions, selected sheets, formulas, values, and structure. Then ask the question Excel can't answer on its own: why did Project IRR move from 12.4% to 11.8%? Material Change Intelligence ranks the drivers, shows the cell-by-cell path each one travelled to the output, and re-perturbs the live workbook ±1% to size each contribution — a real local Jacobian, not pattern matching. Every workbook comparison that touches a signed block writes a BlockBroken record to the Proof ledger; every explanation links back to Review Issues, the Audit Trail, and a generated Output Intelligence worksheet. Workbook Comparison stops being a one-off diff and becomes a traceability event in the model's audit history.
Workbook Comparison
Know why outputs moved.
Demo comingFlagship features
The 3 that matter most.
The features inside this capability that drive the most buyer interest.
Compare Workbooks
Formula-aware diff of two Excel files. Headline metrics split the delta into five buckets (Total / Formula / Value / Formatting / Structural). A Workbook TreeView navigator inside the results window with per-sheet change counts colour-coded by density. Aligned-sheet detection flags sheets whose structure matches between versions so positional changes don't register as structural. Change grouping collapses near-identical edits — 2,730 cells all moving from `=-Cons!X39` to `=-Cons!X40` become one reviewable item. Per-change tagging uses five impact levels (None / Low / Medium / High / Critical), a Significant flag for material financial moves, and Data Validation as a separate change category. Smaller sheets process first so the first results land fast on huge models. Highlight all changes inside Excel itself with one click.
Compare to Previous Version
Diff the active workbook against any earlier file on disk. Auto-discovery walks the workbook's folder for sibling files matching common version-suffix patterns (`*_v*`, `*_version*`, `*_rev*`, `*_backup*`); Browse fallback for anything else. Cloud workbooks (OneDrive, SharePoint) auto-resolve to the local synced copy or get snapshotted to a cache folder so the version picker has a folder to enumerate. Once selected, the same Compare Workbooks engine runs and "Explain Output Change" routes into Material Change Intelligence from the results window in one click.
Material Change Intelligence
Answer "why did Project IRR move from 12.4% to 11.8%?" with attribution math instead of guesswork. Auto-detects the model's outputs across the standard PF/IB metric vocabulary (IRR, NPV, DSCR, LLCR, PLCR, MOIC, Payback, Equity Return) via named-range and label-context scans; a type-ahead lets you specify any cell. Decomposes the delta into up to 8 ranked drivers. Sensitivity-backed contributions actually re-perturb the live workbook ±1% via the Sensitivity engine — a real local Jacobian, not pattern matching. Residual is exact arithmetic: Δ minus Σ contributions. Confidence blends evidence type, path length, and unexplained residual into a single score per driver. For each driver: a cell-by-cell Dependency Path showing the chain from the changed input through every formula it touched on the way to the output. Seven one-click routes from the result — Open In Excel, TrustLens, Formula Diff, Worksheet Map, Create Review Issue, Mark For Audit, Export Report. And the closed loop: every comparison that intersects a signed block writes a BlockBroken record to the Proof ledger; every explanation has an ExplanationId that links Review Issues and the Audit Trail.
Also in this capability
1 more features.
- Compare SheetsCompare specific worksheet pairs across two files. SheetNameMatcher auto-suggests pairings via four-phase fuzzy match (exact → normalized → abbreviation → Levenshtein ≥ 0.6) so a "Revenue" sheet pairs with "Rev v2" even after a rename. Same Compare Workbooks engine underneath: formula-aware, with available R1C1 mode and change grouping.
Same product, more capabilities