‘Excel cannot open the file ‘(filename)’.xlsx’ Error is a common MS Excel error messages that every regular users of Excel might have encountered this error message while they try to access their files.
Let us take the real example of this Excel workbook error – Every now and then when you try to open the Excel spreadsheet you get the following mentioned error message: “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.”
You might have noticed that the files on which you were working on from a very long time now suddenly starts troubling you and start to display the error message when you try to open it. One can also find out the number related with this error message, you just need to press ‘CTRL+SHIFT+I’ altogether. After this you will receive the number “101590” just beside the error message.
There could be two major reasons for the above mentioned error message:
- The Excel file you are using is not compatible with the version of the Excel.
- Or your file got corrupted/damaged.
But you don’t need to worry anymore. The good news is that there are few solutions available that you can perform to fix the above error message and thereafter you can easily open and access data stored in your excel spreadsheets.
Below find out the mentioned solutions that you can perform to fix this error message and get back your saved data from your Excel Sheet:
Solution 1 – Try to Change the Extension of your Excel File
As mentioned above that this error message occurs due to incompatibility with the version of the Excel. In order to find out compatibility of XLSX extension, just go to My Computer> Tools> Folder option> File Types. Now check if “XLSX” extension is available there or not, if not then rename this files extension from “XLSX” to “XLS”.
Solution 2 – Try to use inbuilt “Open and Repair” Utility of MS Excel
To do this Open Excel Sheet, go to File>Open. Now browse the file that you want to repair, but do not double click on it. Now from the “Open” drop down dialogue box select “Open and Repair” option. This will perform the repairing of Excel Sheet and then it will open the file normally.
Solution 3 – Use Excel File Repair Tool
If following above solutions fails to fix the issue and problem still persists then it is recommended that you must use Excel File Repair Tool for Windows/Mac. It is one of the specific software that is made to repair & fix corrupted/damaged or error throwing Excel workbooks and extract entire data saved in it with original file structure. So, what are you waiting for just download Excel Repair tool – Windows or Mac as per system operating system and perform repairing and recovery of corrupt/damaged excel sheet.
You Might Also Be Interested In:
- Fix Excel Error “File Name XLS Cannot Be Accessed”
- 5 ways to recover corrupt Excel workbook
- Resolve “The file is corrupt and cannot be opened” in Excel 2010
- Repair excel xls,xlsx,xlt,xls,xlsm,xlsx
Steps to Fix MS Excel 2007 Error: “Excel cannot open the file ‘(filename)’.xlsx”
Step 1: First download Stellar Phoenix Excel Recovery. Here you have the initial screen of this software with will guide you. Now hit on “OK” button to start the process.
Step 2: To recover you corrupted files (.xls or .xlsx), just hit on “select file” button or if you want to search an excel file click on “search file(s)”. By using “look in” you can search from the particular logical drive.
Step 3: With the help of check box you can select the corrupted file from the search list. To select all corrupted file for scanning click on “select all” box and now to begin the scanning process click on “start” icon.
Step 4: After the scanning process is complete, you have the option to view your corrupt file from right panel.
Step 5: Click on “Start Repair” button to start the repairing process, select the location to save your repaired excel file and at last click on “OK” button.
You can try any of the following solutions mentioned above to resolve this error messages. But if you ask me then I would suggest you to first try the manual method and if it fails then I would highly recommend you to use third party Excel File Repair Tool.