Important: Spreadsheet Compare is only available with Office Professional Plus 2013, Office Professional Plus 2016, Office Professional Plus 2019, or Microsoft 365 Apps for enterprise.
Use Spreadsheet Compare to compare two workbooks to see the differences between them, line by line. You can see how values, formulas, and formatting differ – line by line, and cell by cell.
Spreadsheet Compare can detect and highlight just the type of differences you specify.
Read the following articles for more information and step-by-step procedures.
Compare two versions of a workbook
See detailed changes between workbooks
Manage passwords used to open files for analysis and comparison