How to Compare Excel Versions and Display Changed Rows
Question details
The user wants to compare the current Excel workbook with a previous version to see only changed or added rows, specifically inquiring about the Inquire feature and automatic comparison.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Comparing different versions of a workbook to track data modifications and potentially automating the comparison process upon opening.
- Observed behavior
- The Inquire tab is missing for some users depending on their Office edition, and comparing files automatically requires advanced VBA or Office Scripts setup.
Verify your Microsoft Office edition before proceeding, as the built-in Inquire add-in is exclusively available in Office Professional Plus and Microsoft 365 Apps for enterprise editions.
Enable and Use the Inquire Add-in
If you have a supported enterprise edition of Excel, you can enable the built-in Inquire tool to compare two workbooks side-by-side and highlight changed rows.
The Inquire add-in is the most robust way to analyze changes between workbooks, but it is restricted to specific enterprise licenses.
Go to File > Options > Add-Ins. In the Manage drop-down box at the bottom, select COM Add-ins, and click Go.
Check the box next to 'Inquire' in the Add-ins available box and click OK. The Inquire tab will now appear on your Excel ribbon.
Open both the current and previous versions of your workbook. Go to the Inquire tab, click Compare Files, and review the highlighted changes grid.

Use OneDrive or SharePoint Version History
If you do not have the enterprise edition of Office, you can use version history to retrieve older files and manually compare them.
Automate Workbook Comparison using VBA
To have the file automatically compare itself with a previous version whenever it opens, you must use a custom VBA macro.
Try WPS Office for Seamless Spreadsheet Management
If your current Excel edition lacks advanced comparison tools or requires expensive enterprise upgrades, consider WPS Office. It provides a lightweight, highly compatible alternative for everyday spreadsheet management and data analysis without the steep enterprise costs.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package for your operating system.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly to continue your work without losing any formatting.

Frequently Asked Questions
Why is the Inquire tab missing in my Excel?
The Inquire tab is a premium feature included exclusively in Microsoft Office Professional Plus and Microsoft 365 Apps for enterprise. Other editions, such as Home, Personal, or Standard, do not include this add-in.
Can I automatically compare Excel files when they open?
Yes, but it requires advanced scripting. You must write custom VBA (Visual Basic for Applications) scripts or use Office Scripts to trigger a comparison routine automatically during the Workbook_Open event.
Is there a way to compare Excel files without the Inquire add-in?
Yes. You can manually arrange sheets side-by-side using View > View Side by Side, apply conditional formatting to highlight differences between two sheets, or use third-party spreadsheet comparison software.




