Fix Excel's XLS File Format and Extension Warning
Question details
The user needs to open an XLS workbook when Excel warns that its file format and extension do not match.

- 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.
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.
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.
In Windows File Explorer, open View and enable File name extensions. In Windows 11, select View > Show > File name extensions.
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.
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.
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.

Check Windows and Excel security settings
Use these checks if a trusted workbook is blocked or opens in Protected View.
Repair the workbook or Office installation
Try these options if a trusted file still cannot be opened after its format and security settings have been checked.
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.

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.




