Data Import & Export

How to Compare Excel Versions and Display Changed Rows

Guest WriterGuest Writer Oct 9, 2026 870 views

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.

How to Compare Excel Versions and Display Only Changed Rows
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.
Before you start

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.

Solution 1Recommended

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.

1
Open COM Add-ins

Go to File > Options > Add-Ins. In the Manage drop-down box at the bottom, select COM Add-ins, and click Go.

2
Enable Inquire

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.

3
Compare Files

Open both the current and previous versions of your workbook. Go to the Inquire tab, click Compare Files, and review the highlighted changes grid.

Enable and Use the Inquire Add-in
Edition Limitation: If you do not see 'Inquire' in the COM Add-ins list, your version of Microsoft 365 or Office does not support this feature.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download the free installation package for your operating system.
  2. 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your device.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly to continue your work without losing any formatting.
Free to use with a familiar, user-friendly interface that requires no learning curve.Highly compatible with Microsoft Office formats, ensuring seamless handling of .xlsx, .xls, and .csv files.Lightweight software that runs smoothly on older or lower-spec devices.Built-in track changes and intuitive review tools for easy collaboration.
microsoft office alternative - wps office

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.