Forum Discussion
Excel cannot be open the file 'filename.xlsx' because the file format or file extension is not valid
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 hav...
I believe as the error statement correctly suggests the error is being caused due to invalid extension. Don’t worry there are several workarounds to this, I am sharing them below:
What Causes ‘Excel File Extension not Valid’ Error?
The error may occur due to any of these reasons:
1) The file is not compatible with the MS Excel version.
2) The Excel file is corrupt or damaged
FIX:
Method 1 – Change the Default File Format to Save Excel Workbooks
• In Excel 2007, click the ‘Microsoft Office’ button and then ‘Excel Options’. In Excel 2010 and higher versions, click File > Options.
• Select Export option.
• Select Change File Type option.
• Change the file extension, and then click Save As.
Method 2 – Recover Unsaved Workbook
• Go to File and select Info option.
• Under Manage Versions, select ‘Recover Unsaved Workbooks’ op
• If MS Excel has unsaved files then, it will list them. You can open and save it.
Method 3 – Use 'Open and Repair' Feature of MS Excel
• Open MS Excel application.
• Go to File and Select Open option.
• Select the corrupt file and choose Open and Repair option.
You can also check this forum: https://social.technet.microsoft.com/Forums/office/en-US/63020ccc-51d7-46d9-b956-121c0e6efcc8/excel-file-error-the-file-format-and-extension-dont-match?forum=Office2016ITPro
What Causes ‘Excel File Extension not Valid’ Error?
The error may occur due to any of these reasons:
1) The file is not compatible with the MS Excel version.
2) The Excel file is corrupt or damaged
FIX:
Method 1 – Change the Default File Format to Save Excel Workbooks
• In Excel 2007, click the ‘Microsoft Office’ button and then ‘Excel Options’. In Excel 2010 and higher versions, click File > Options.
• Select Export option.
• Select Change File Type option.
• Change the file extension, and then click Save As.
Method 2 – Recover Unsaved Workbook
• Go to File and select Info option.
• Under Manage Versions, select ‘Recover Unsaved Workbooks’ op
• If MS Excel has unsaved files then, it will list them. You can open and save it.
Method 3 – Use 'Open and Repair' Feature of MS Excel
• Open MS Excel application.
• Go to File and Select Open option.
• Select the corrupt file and choose Open and Repair option.
You can also check this forum: https://social.technet.microsoft.com/Forums/office/en-US/63020ccc-51d7-46d9-b956-121c0e6efcc8/excel-file-error-the-file-format-and-extension-dont-match?forum=Office2016ITPro