Spreadsheet Compare Greyed Out? Which Command to Check and How to Fix It

If an Excel comparison button is greyed out, read its full name before changing workbook settings. Inquire → Compare Files, the separate Spreadsheet Compare application, and Compare and Merge Workbooks are different entry points. The last one belongs to an older sharing workflow; adding its button will not turn it into a general comparison tool.

Identify the command that is unavailable

A missing feature and a disabled command are different diagnoses. The Spreadsheet Compare availability guide covers editions and installation. This guide focuses on choosing the right command and checking its immediate context.

For Inquire Compare Files, open both workbooks

Microsoft’s Inquire comparison instructions say that two workbooks must be open in Excel to run Compare Files. Open the earlier version and the later version, then return to Inquire → Compare Files. Having only one workbook open is a useful first check when that command is unavailable.

If the tab itself is absent, Microsoft’s Inquire setup guide limits it to eligible Excel for Windows editions. Check File → Options → Add-ins → Manage: COM Add-ins → Go. Enable Inquire if it is listed. If it is not listed, confirm eligibility and any administrator restrictions instead of assuming every Microsoft 365 plan includes it.

These Windows add-in steps do not apply to Excel for Mac. For that platform, use the Mac comparison walkthrough. If opening the files and checking the eligible installation does not resolve the issue, record the exact command, Excel version and message for your administrator; a disabled button alone does not identify every possible cause.

Why Compare and Merge Workbooks can lead you down the wrong path

Microsoft groups Compare and Merge Workbooks with the legacy Shared Workbook commands. Those commands were removed from the usual ribbon in newer Excel versions as co-authoring replaced the old workflow. A toolbar button can still be visible even when your current workbook is not in the workflow it expects.

If you are already maintaining a legacy shared workbook, work with its owner to establish how its copies and change history were created. A downloaded report and last month’s independent export are not automatically eligible merge copies. Do not switch sharing modes merely to make a button light up.

For someone who needs to find a hidden legacy command on Windows, Microsoft documents File → Options → Quick Access Toolbar → All Commands, then adding the required command. That restores access to the button; it does not satisfy its workbook requirements or install Spreadsheet Compare.

Keep collaboration settings separate from file comparison

Microsoft describes Shared Workbooks as an older feature with significant limitations and recommends co-authoring for collaboration. Comparing two exports usually needs neither a new collaboration setup nor changes to the source workbook’s sharing settings.

First decide what result you need. A workbook inspection tool can examine formula text and formatting. A record comparison answers which invoice, customer or SKU was added, is absent, or has different field values. Neither question is answered just by enabling a merge button.

Compare exported records without fixing the legacy command

For two XLSX or CSV tables, TidyCell Compare Files offers a browser workflow based on record IDs. The comparison runs locally and creates a separate Excel report.

1. Choose the earlier file first and the later file second. Select the worksheet from each workbook when needed.
2. Check the suggested unique ID, or choose a composite key such as SKU plus Warehouse. Confirm the fields you want compared.
3. Review Added, Removed, Changed, Unchanged and Needs review. Duplicate or missing IDs are not silently matched.
4. Check the source-row totals, then download the separate XLSX report with Summary, Records, Cell changes and Needs review worksheets.

This is a stored-value comparison, including saved formula results. It does not recalculate formulas, compare formula text, audit formatting or merge edits into either original. For an export whose rows have moved or increased, see how to compare files with different row counts.

What should you check before trusting the result?

If you came looking for an Excel equivalent of Word’s Compare, use the two-workbook-version guide to distinguish record changes, formula inspection and recorded edit history.

Confirm one known change against the source files, then check a record that moved without changing. A record absent from the second export might reflect a filter or reporting date rather than a deletion. If your actual question is who edited a cell and when, inspect change history captured by the collaboration system; two exports alone cannot establish that history.