File Format & Compatibility

Fix Excel's XLS File Format and Extension Warning

Khadija KhanKhadija Khan Nov 22, 2026 868 views

Question details

The user needs to open an XLS workbook when Excel warns that its file format and extension do not match.

Fix Excel's XLS File Format and Extension Warning
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
Opening an older Excel workbook, such as an Excel 97 XLS file, in Microsoft 365.
Observed behavior
Excel displays a format and extension mismatch warning and may not open the workbook.
Before you start

Confirm that the workbook came from a trusted source and ask the sender which format it was saved in. The Windows-specific steps below apply to Excel and File Explorer on Windows.

Solution 1Recommended

Verify the workbook's format and extension

Use this approach when the file may have been renamed with an extension that does not match its actual format.

1
Show file extensions

In Windows File Explorer, open View and enable File name extensions. In Windows 11, select View > Show > File name extensions.

2
Confirm the actual format

Check the file's source or ask the sender whether it was saved as an Excel 97–2003 workbook (.xls), Excel workbook (.xlsx), or macro-enabled workbook (.xlsm). Do not rely on the extension alone.

3
Correct a mislabeled extension

If the actual format is confirmed and only the extension is wrong, right-click the file in File Explorer, select Rename, and change the extension to match. Renaming an extension does not convert the file.

4
Open the workbook

In Excel, select File > Open and choose the file. If the format is still uncertain or the warning remains, ask the sender to save and resend it in a supported Excel format.

Verify the workbook's format and extension
Treat unexpected warnings cautiously: A mismatch can be a security risk. Do not open a file you do not trust or enable its macros just to bypass the warning.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Excel format compatibility helps you move existing files into your workflow, though it does not fix Excel's own security settings or repair installation problems.

Open and edit many XLS and XLSX spreadsheets in WPS SpreadsheetsCompatible with common Microsoft Office formats, including Excel XLS and XLSXFamiliar spreadsheet interface for an easier transitionFree, lightweight office suite for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say the file format and extension do not match?

The file may have been given an extension that does not reflect its actual format, or it may be damaged. Confirm its original format with the sender before changing the extension or opening it.

Does renaming an XLS file to XLSX convert it?

No. Renaming changes only the extension. To convert a workbook, open it in a compatible spreadsheet application and use File > Save As to choose the desired format.

Where can I check whether Excel blocks older workbook formats?

In Excel for Windows, go to File > Options > Trust Center > Trust Center Settings > File Block Settings. Review the relevant Excel file type and follow your organization's security policy.

How can I repair a damaged workbook in Excel?

Select File > Open > Browse, select the workbook, and choose Open and Repair from the arrow next to Open. Try Repair first; if it fails, you can try Extract Data.