BuyDownload

Guide

Compare formulas between Excel workbooks

Separate formula source, calculated value, relative-reference alignment, and array formula range changes.

In short: Separate formula source, calculated value, relative-reference alignment, and array formula range changes.

ValuesCalculatedFormulasStructureNamesCommentsVBAConnectionsFormattingProtection
xlLens
Search changes✓ Differences onlySave report
BasicSmartTable80 changes
PreviousBudget-2025.xlsx
ABCD
4Revenue475,000,000118.8%OK
5Operating profit118.8%=C5*1.08OK
6New customers531,360,000120.8%OK
7Repeat sales73.8=E7*1.0892.5
CurrentBudget-2026.xlsx
ABCD
4Revenue482,000,000118.8%OK
5Operating profit120.5%=C5*1.10OK
6New customers541,200,000120.8%OK
7Repeat sales73.75=E7*1.1092.50
Sheet 1 19Change detailsVBA 1
RevenueB4475,000,000482,000,000

10 change types in one workspace

Review multiple semantic changes side by side while preserving the visual structure of the desktop product.

xlLens
Search changes✓ Differences onlySave report
BasicSmartTable80 changes
✓ Matched by key: 4 + Inserted row: 1
PreviousORD-101#101ORD-102#102ORD-103#103ORD-104#104
CurrentORD-101#101ORD-NEWInserted rowORD-102#102ORD-103#103ORD-104#104

Smart alignment

See inserted and removed rows realigned without a cascade of false changes.

xlLens
Search changes✓ Differences onlySave report
BasicSmartTable80 changes
Key column✓ SKUIDEmail
PreviousA-100Desk$180B-200Chair$80C-300Lamp$45
CurrentC-300Lamp$45B-200Chair$92A-100Desk$180

✓ B-200 · Matched by key · row 2 → 2

Key-based Table mode

Match reordered business records by SKU, ID, email, or another selected key.

Formula text and calculated value are different evidence

Two cells can display the same value while using different formulas, or keep the same formula while cached results differ. xlLens classifies formula source, input value, and calculated value separately.

Account for moved rows and columns

Smart mode aligns inserted or deleted rows and columns, then normalizes relative references so address movement is not automatically treated as a formula rewrite. Basic mode remains available for strict address audits.

Review formula ranges and dependencies

Array-formula ranges and data-table formulas appear as distinct workbook semantics. Formula dependency and risk analysis can be exported to CSV or SVG for a wider model review.

Preserve the audit trail

Filter to formula changes, inspect both original cell addresses, and export the comparison rules and source hashes with the result.

Next step

Try xlLens

SUPPORT

Need help?

Report a bug

Found a bug? Include the following details in your email.

  • Device and OS version
  • xlLens app version
  • Description of the issue
  • Screenshot or sample file, if possible