"Excel cannot open the file
'filename.xlsx' because the file format for the file extension is not valid.
Verify that the file has not been corrupted and that the file extension matches
the format of the file."
This is one of the common error
message excel user face when they try to open a spreadsheet received in an
email.
But this error message is not only for
the Excel files which user receives via emails. You can even get this error
with any of the used files. You may get this error on the Excel workbook, on
which you were working for long time.
To see the unique number linked with
this error message, you just need to press 'CTRL+SHIFT+I' together. After
this you will get the number besides the error message: "101590"
But do you actually know what are
the main causes behind getting this error message:
Causes: you might get this error message when:
·
Incompatible file with the excel version
you are using.
·
Corrupted excel file.
Resolutions: Try out the below mentioned
solutions to rectify this error message and access
to your Excel sheet.
Solution#1
Modify the File Extension of Your Excel Sheet: Sometime the problem is in the unsupported file extension
of the Excel file you are using. To check out the Excel file extension, move to
'My Computer'. Browse 'Tools >> Folder Options >> File Types'.
Check whether 'xlsx' extension is included or not. If it is not then rename
this file and modify '.xlsx' to '.xls'.
Solution#2
Use 'Open and Repair' Option: To do this open Excel, and then move to 'File >>
Open'. Choose the file that you want to open, but don’t double click on it.
Move to 'Open' drop-down provided in 'Open' dialog box, choose 'Open and
Repair' option.
Solution#3
But, if none if the above steps work
for then use Excel Repair Software, which is a professional tool to repair the corrupt, excel sheet
and restores the entire data without altering its original formatting.
For more visit: http://www.repairmsexcel.com/blog/how-to-fix-excel-cannot-open-the-file-filename-xlsx-error-of-ms-excel-2007
If your MS Excel File get corrupted due to virus attack, missing MS office files, power failure and other possible reason that can be fixed by only use any third party Excel Recovery Tool tool. I Suggest to you Excel File Recovery Tool, because it is integrated with skillful interface that ensures repair your corrupted or damaged excel file with quick and full accuracy. To more details:- http://www.softmagnat.com/excel-recovery.html
ReplyDelete