Compare Excel files with Inquire

https://support.microsoft.com/en-us/office/compare-workbooks-using-spreadsheet-inquire-ebaf3d62-2af5-4cb1-af7d-e958cc5fad42

Tips&Tricks

Excel has a built-in way to compare two Excel files using the Inquire add-in. The full description is listed in this Microsoft support article: https://support.microsoft.com/en-us/office/compare-workbooks-using-spreadsheet-inquire-ebaf3d62-2af5-4cb1-af7d-e958cc5fad42

Excel Inquire Ribbon

This requires enabling Inquire first.

  1. Enter File > Options > Add ins
  2. Set "Manage" to "COM Add-ins"
  3. Click Go
  4. Place a check-mark next to "Inquire"
  5. Click OK.

The steps are copied from this Super User answer.