As file conflicts can easily occur in the new and shiny world of SharePoint/OneDrive-based Excel 365 it is important to be able to compare different versions of a file.
All info I found online talks about older versions of Excel.
How can I compare two Excel files in Excel 365? I need to see a useable overview of all their differences, ideally with a way to merge them.
1 Answer
You may compare two Excel spreadsheets using the ribbon entryInquire > Compare Files. You need to have two workbooks open in Excel to run this command.
For more information about the command, see the Microsoft article
What you can do with Spreadsheet Inquire.
The Inquire pane is not enabled by default in Excel.
- Enter File > Options > Add ins
- Set "Manage" to "COM Add-ins"
- Click Go
- Place a check-mark next to "Inquire"
- Click OK.
