FIX: File format and extension don’t match on Excel

Radu Tyrsina
by Radu Tyrsina
CEO & Founder
Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time). For most of the kids of his age, the Internet was an... Read more
Affiliate Disclosure

Microsoft Excel is probably the most used spreadsheet tool in the world.

The guide below will show you how to handle File format and extension issues in Excel.

To read more about this amazing tool, visit our Excel Hub.

For more MS Office-related tutorials, check out our Microsoft Office How-To page.

file format and extension don't match
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

If you rename a file extension from one Excel format to another (e.g., from a .xlsx to .xls), you get the following error message:

The file format and extension of .xls don’t match. The file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?

Microsoft Excel opens files in various formats, such as .xls, .xlsx, .xlsm, .xlsb, .xltx, .xml, and many more. This error also gets worse. If you click Yes, the file opens anyway, but with all of its content missing.

Of course, like all error messages, the format and extension don’t match error can be as a result of other underlying issues, the most common of which is that the document is deemed to be corrupt.

Here is what to do when faced with this challenge.

How do I fix the file format and extension match error?

1. Unblock access for safe files

  1. Go to the folder which contains the Excel file.
  2. Right-click on the document you are trying to open.
  3. From the options, select Properties.
  4. Next, on the General tab hit Unblock.
  5. Finally, click on the OK.

2. Add the workbook to a Trusted Location

  1. Launch Ms Excel.
  2. Click File on the toolbar and then choose Options.
  3. Next, in the resulting screen, click Trust Center.fix file format and extension don't match: click trust center
  4. Finally, click on Trust Center Settings and select Trusted Locations on the left sidebar.add a trusted location to repair the file format and extension don't match error

In Microsoft Excel 2010, 2013, and 2016, saving a file to a Trusted Location lets the program view it as safe. Excel comes with default trust locations, and you can add others by clicking the Add new location button.

Save the problematic worksheet in a trust location and try to open it again. However, you must note that if a malicious person places a file in a trusted location, Excel will overlook this document also.

3. Repair the workbook to fix file format and extension don’t match error

  1. Launch Microsoft Excel.
  2. Click the File menu on the toolbar and hit Open.
    • This will open the dialog box to browse for the file.
  3. From the dialog box, click Browse and find the workbook that gives the file format and extension don’t match.
  4. Next, instead of opening this file straight away, click on the little arrow beside the Open button and choose the Open and Repair option from the and repair worksheet to fix file format and extension don't match error
  5. Finally, click Repair. This should now recover the content of the problematic workbook.
  6. If the Repair operation fails to restore all the formulas and values from the workbook, try again by using the Extract Data

These solutions above should clear the file format and extension don’t match error. However, if all fail, backing up the workbook or creating a recovery file can salvage your data.

In the next section, we will explore how to recover data from the problematic file, as well as how to back up the workbook.

4. Change the calculation setting to manual from automatic

  1. Launch Microsoft Excel.
  2. Click on the File menu on the toolbar and hit New.
  3. Next, click on Blank workbook. This will open a new workbook with no values.
  4. Now, click on file again, but this time, select Options.
  5. Navigate to Formulas, and under Calculation options, select Manual.manual formula calculation fixes file format and extension don't match error
  6. Hit OK.

Now open the workbook and confirm that the file no longer gives the file format and extension don’t march error or opens blank sheets.

In conclusion, the file format and extension don’t march error comes, especially when you rename an Excel file to another extension.

We have looked into troubleshooting this issue by unblocking files, saving and opening the workbook from a trusted location, and repairing the file.

Also, we went over preventive measures to take on your worksheet, so that you do not lose data. Are you experiencing this issue or got it in the past? How did you resolve it?

We appreciate your comments and will get to as many as possible.

Frequently Asked Questions

This article covers:Topics: