Forum Discussion
In Excel: "The file format and Extension don’t match”.
This error is coming repeatedly even, I am clicking on Yes, and the file is corrupted. How do I repair my file? Is there any solution to recover my file?
Hello Adi,
I am glad to assist you; please try the below solutions to repair your file.
Solution 1: Change the default file format.
Try changing the Excel default file format by following these steps:
- In Excel 2010 and newer versions, click on the File menu.
- Then, in the Info screen that appears, click on Options.
- In the 'Excel Options' window, under the Save workbooks section, click on the Save files in this file format: drop-down. Next, select a file format (i.e., the one supported by your Excel version).
- Click OK.
Check if you can open your Excel file. If not, try the next solution.
Solution 2: Edit the excel file permissions
Follow these steps to change the file permissions and see if it fixes the problem:
- Right-click on the file that will not open and click Properties.
- In the file properties dialog box, click the Security tab and hit the Edit button.
- When the file's permissions dialog box appears, click on the Add button.
- Next, click on the advanced button from the 'Select Users or Groups' window.
- Select Find Now. A list of all users and groups will be displayed in a search results box. Choose everyone's group from the list and hit OK.
- You can see the 'Everyone' group in the 'Enter the object names to select' textbox. Click OK once again to return to the file's permission dialog box.
- Click everyone from the Group or user names: box and check all the checkboxes under Allow.
- Click on Apply and then OK.
Now try to open the Excel file. If you are still getting the Excel file cannot open error, you can refer to the following thread and article: