Formula to formula
Review the old and new stored expressions when the same coordinate contains a formula in both workbooks.
Excel formula diff
Compare formula changes between Excel workbooks
Use an original and revised `.xlsx` workbook to check the stored expression at the same cell coordinate. WorkbookDiff separates formula edits from value edits, including the case where a formula in the original was replaced by a stored value in the revision.
Stored formulas, not recalculated results
Catch formulas that changed—or were replaced by values
Formula to value
Surface a cell whose original formula became a hard-coded value in the revised workbook.
Value to formula
See when a previously entered value was replaced by a stored formula expression.
Filter and export
Filter supported findings and export the difference list as CSV for manual review.
WorkbookDiff compares stored formula expressions by cell coordinate. It is not a formula authoring assistant, dependency mapper, or recalculation engine, and it cannot reconcile formulas after rows are reordered.
Exact-output example
See the formula transition, not only the displayed result
ChangeCellOriginalRevised
Formula changedForecast!F8=SUM(F2:F7)=SUM(F2:F7)*1.05
Formula → valueBudget!B12=B8+B926500
Value → formulaInputs!D40.08=Rates!B2
The example shows the type of stored-expression difference WorkbookDiff reports. It does not prove that two different formulas are mathematically equivalent.
Controlled old/new workbook pair
Run the exact formula-change audit proof
Download both synthetic `.xlsx` files, open the main tool, select Original first and Revised second, then compare locally. The displayed totals stay the same while the stored calculation logic changes.
1. Download Original
Contains the starting formula/value types at the same Budget coordinates.
Download Original XLSX2. Download Revised
Contains one formula edit, one formula replaced by value, and one value replaced by formula.
Download Revised XLSX30-second controlled proof
See matching totals hide three formula-type changes
The privacy-enhanced YouTube player loads only after you press play. The video uses the same synthetic starter pair and does not claim a formal audit or customer result.
Quick answers
Excel formula diff FAQ
Can it detect a formula replaced by a value?
Yes, when the workbooks remain coordinate-aligned and the transition occurs at the same worksheet and cell address.
Does it recalculate formulas?
No. It compares stored expressions and stored values; it does not execute Excel's calculation engine.
Can it match formulas after rows move?
No. Reordered records require key-based reconciliation before field comparison.
Can I export the findings?
Yes. Run the main comparison, filter the supported differences, and export the current result as CSV.