Use Spreadsheet Compare to find differences between two Excel workbooks.
To compare two open workbooks in Excel, you can use Spreadsheet Compare, which is available on Office Professional and enterprise. If you don't have this, open both workbooks, click the View tab, and then click View Side By Side.
In this Excel tutorial, I will show you multiple ways to compare two different Excel files (or sheets) and check for differences. The method you choose will depend on how your data is structured and what kind of comparison you’re looking for.