Excel cannot be open the file 'filename.xlsx' because the file format or file extension is not valid

%3CLINGO-SUB%20id%3D%22lingo-sub-1504346%22%20slang%3D%22en-US%22%3EExcel%20cannot%20be%20open%20the%20file%20'filename.xlsx'%20because%20the%20file%20format%20or%20file%20extension%20is%20not%20valid%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504346%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20excel.xlsx%20file%20saved%20in%20my%20system%20which%20has%20been%20corrupted%20.I%20atleast%20need%20to%20recover%20the%20data%20stores%20.It%20is%20a%20file%20of%20124%20KB%20and%20has%20around%2035%20worksheets%20in%20the%20workbook%20.I%20have%20tried%20all%20possible%20ways%20to%20recover%20and%20repair%20the%20file%20.i%20even%20tried%20to%20extract%20the%20data%20using%203rd%20party%20application%20like%20stellar%2Cease%20of%20use%20recover%20application%20of%20excel%20still%20i%20have%20no%20luck%20.%20The%20below%20error%20message%20im%20getting%20whenever%20i%20try%20to%20open%20the%20file.I%20even%20tried%20to%20open%20it%20through%20other%20applications%20like%20wordpress%2Cgoogle%20sheets%20and%20so%20on%20but%20nothing%20works%20.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Muthu69_0-1593864048764.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203263iB852D581C454C9B4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Muthu69_0-1593864048764.png%22%20alt%3D%22Muthu69_0-1593864048764.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20regards%20%2C%3C%2FP%3E%3CP%3EMuthuraman%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1504371%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cannot%20be%20open%20the%20file%20'filename.xlsx'%20because%20the%20file%20format%20or%20file%20extension%20is%20not%20v%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504371%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20attach%20the%20file%20for%20me%20to%20figure%20how%20to%20solve%20this%20for%20you%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1656863%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cannot%20be%20open%20the%20file%20'filename.xlsx'%20because%20the%20file%20format%20or%20file%20extension%20is%20not%20v%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1656863%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20error%20message%20is%20encountered%20in%20the%20following%20scenarios%3A%3C%2FP%3E%3CUL%3E%3CLI%3EThe%20file%20is%20not%20compatible%20with%20the%20Excel-version%3C%2FLI%3E%3CLI%3EThe%20file%20has%20become%20corrupt%20or%20damaged%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20copied%20and%20pasted%20the%20file%20to%20my%20desktop%2C%20right-click%20and%20changed%20'.xlsx'%20to%20'.xls'.%20Boom!!%20I%20got%20my%20file%20back.%3CBR%20%2F%3ETry%20to%20open%20your%20corrupt%20file%20in%20safe%20mode.%20Press%20Windows%2BR%20and%20write%20excel.exe%20%2Fsafe%20and%20click%20OK.%26nbsp%3B%26nbsp%3B%20Good%20Luck%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi All,

 

I have a excel.xlsx file saved in my system which has been corrupted .I atleast need to recover the data stores .It is a file of 124 KB and has around 35 worksheets in the workbook .I have tried all possible ways to recover and repair the file .i even tried to extract the data using 3rd party application like stellar,ease of use recover application of excel still i have no luck . The below error message im getting whenever i try to open the file.I even tried to open it through other applications like wordpress,google sheets and so on but nothing works .

Muthu69_0-1593864048764.png

 

 

Thanks and regards ,

Muthuraman

7 Replies
Highlighted
Hello,

Can you attach the file for me to figure how to solve this for you?
Highlighted

This error message is encountered in the following scenarios:

  • The file is not compatible with the Excel-version
  • The file has become corrupt or damaged

I copied and pasted the file to my desktop, right-click and changed '.xlsx' to '.xls'. Boom!! I got my file back.
Try to open your corrupt file in safe mode. Press Windows+R and write excel.exe /safe and click OK.   Good Luck

Highlighted

@Muthu69 Hi. If you have tried all possible methods to repair your Excel file but none of them work, then maybe your Excel file is not corrupted, but you just don’t have permission to open it on your system. If you don’t have permission to open the Excel file, it will display the error "Excel cannot open the file because the file format or file extension is not valid." I have tested this on my Windows 10.  You can use the following steps to grant everyone on this computer permission to open the Excel file. 

  1. Right-click the Excel file that cannot be opened and select Properties.
  2. After the file’s Properties dialog opens, select the Security tab, and then click the Edit button.
  3. After the file’s Permissions dialog opens, click the Add button.
  4. When the Select Users or Groups dialog opens, click the Advanced button. When the next dialog opens, click Find Now so all users and groups will show up in the search results list at the bottom of the dialog. Select the Everyone group from the list, and then click OK. Click OK again.
  5. When you return to the Permissions dialog, you will see the Everyone group has been added to the group or user list. Select the Everyone group, check all checkboxes under Allow, and then click Apply.

That’s it. Now check if you can open the Excel file without any problems. If you want an illustrated guide, refer to this page: https://www.isumsoft.com/office/excel-cannot-open-the-file-because-extension-is-not-valid.html#way2

 

Please tell me if this helps. Good luck!

 

Highlighted
"I copied and pasted the file to my desktop, right-click and changed '.xlsx' to '.xls'. Boom!"

What did you click on when you right clicked in order to change the file type from xlsx to xls? Because I just tried this and cant figure it out.
Highlighted
I just tried this and it didnt work. Its still telling me the file doesnt match. So basically my excel file wont open as an xlsx or an xls? Why not?!!! This is really annoying!!! I just got a new laptop and im trying to open my bills spreadsheet, but for the life of me cant get the file to open. This is ridiculous!! I just want to open the dang file. Why does everything have to be so fricken complicated!??!?!
Highlighted

@Muthu69 

With your permission and everyone involved, if I can recommend.

It can help us all if you upload an Excel file, no picture.

You could get a precise solution much faster with a file.

This would also be a blessing for all of us,

as we can understand the problem much better,

a win-win situation for everyone.

 

*Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

Highlighted