How to Compare Two Excel Workbooks
Comparing two Excel workbooks is important when you need to understand what changed between versions.
This is common in finance, accounting, consulting, operations, and client reporting.
Why compare Excel workbooks?
You may need to compare two files when:
- someone sends a revised version
- you inherit a workbook
- a client changes a template
- formulas may have been modified
- numbers no longer match
- assumptions changed
- you need to review before approval.
What should be compared?
A good workbook comparison should check more than cell values.
You should compare:
- sheet names
- added or deleted sheets
- cell values
- formulas
- formatting
- named ranges
- hidden sheets
- hidden rows and columns
- external links
- merged cells
- row and column structure.
Manual comparison method
For small workbooks, you can open both files side by side.
Go to:
View → View Side by Side
Then review key sheets manually.
This works for simple files, but it is not reliable for large workbooks.
Use formulas to compare values
If both sheets have the same structure, you can use formulas such as:
=A1='[OtherWorkbook.xlsx]Sheet1'!A1Or:
=IF(A1<>B1,"Changed","")This helps identify differences, but it requires setup.
Compare formulas, not just values
Two cells can show the same value while using different formulas. That matters because the result may change later.
For example:
=Revenue-Costand
=Revenue*0.30may produce the same number today but represent different logic.
Watch for hidden changes
Some changes are easy to miss:
- hidden rows
- hidden columns
- hidden sheets
- changed named ranges
- broken external links
- overwritten formulas
- changed assumptions.
Best practice
Before approving a revised workbook, create a comparison checklist:
- Are all expected sheets present?
- Were any sheets added or deleted?
- Did formulas change in key areas?
- Did input assumptions change?
- Did totals change?
- Are there new external links?
- Are there new hidden sheets or rows?
Conclusion
Comparing two Excel workbooks manually can be time-consuming and risky. The most important differences are often hidden in formulas, structure, links, or assumptions.
SaferSheets is built to help users detect spreadsheet risks and can support workbook review workflows where version control matters.