When it comes to spreadsheet applications, Microsoft Excel is widely used by most small and large organizations for the organization of data, whether that be in the form of financial analysis, quarterly reports, or other tasks that require data aggregation. Unfortunately, it is very common to get the error “Excel cannot open the file [filename].xlsx because the file extension is not valid” when trying to open or edit an Excel File in Office 2003, 2007, 2010, 20013, 2016, or 2019. Reasons for this error occurring include the file not being compatible with the Excel version you are using, or the file is damaged or corrupted. There are several solutions to this problem, of which we are going to mention four and provide you with a way to protect your future Excel files from being lost.
Try the below methods to fix Excel cannot open the file issue.
The most common reason why Excel cannot open a file is because the file extension is unsupported by the version of Excel that you are trying to open it with. To determine if this is the case, find out if your Microsoft Excel supports the .xlsx extension type.
Step 1: Open Microsoft Excel and choose a file that you have previously opened. Click on the menu from here.
Step 2: Move your cursor down until you see the export option and click it. Choose the Change File Type option and check to see if you have the XLSX Workbook option as an export format. If you do, then the file extension is not the issue.
Step 3: If you do not, then you will need to change the extension of the file by going to your My Computer and selecting “view” at the top. This will allow you to find the tiles section, which includes an open for enabling file name extensions.
Step 4: Once the file name extensions box is check marked in the My Computer, you can go ahead and change the file extension.
If you are still getting the Excel Cannot Open the File.xlsx after enabling the file extension feature, try opening and repairing the excel file.
Step 1: Open Microsoft Excel and on the File Menu, click the Open option.
Step 2: In the dialogue box that comes up, select the excel file that is giving you the error.
Step 3: Instead of hitting open, click the down arrow and select the Open and Repair option.
Step 4: Microsoft Excel will check the document and repair it if corruption or damaged is found. Once fixed, you should be able to open the document.
If the current version of your Microsoft Excel program still cannot open the excel file, try using a previous version.
Step 1: In your File Explorer, find where you saved the excel file.
Step 2: Right-click it and choose properties.
Step 3: On the properties window that pops up, click on previous version.
Step 4: Select which previous version you would like to use and click restore.
Step 5: If you have the autosave feature on, it will eliminate the excel cannot open the file because the file extension is not valid error, as it will save over top of the excel file with the previous version.
Step 6: If your file has been automatically saved, find it in the Taskbar and right-click it and select restore. This will prompt you to save the file, give it a new name, and choose the file extension you want to save it as.
You can try opening the file while you are in safe mode. Safe mode on Windows computers allows users to fix most problems with the operating system as it only boots essential system programs and services.
Step 1: Press Windows + R key to open the Run command. Type in excel.exe/safe and hit the okay button.
Step 2: Find the file in Excel and save it as a .xlsx.
Step 3: Close the application and reboot the computer, so you are no longer in safe mode. Open the file as normal.
If you have encountered data loss, whether that be due to Excel crashing when saving, having your operating system crash during a save, or having your hard drive become corrupted or damaged, you can still retrieve your excel files. You will need to use a professional data file recovery tool like AnyRecover to help. AnyRecover works with a 98% accuracy and it allows you to recover all kinds of document files including PDFs, DOCs/DOCXs, XLS/XLSXs, HTML, and more.
1,000,000 + Downloads
Features of iMyFone AnyRecover:
Recover Excel files that were corrupted, deleted, or lost from software updates.
Recover data from any storage device, including computer, external hard drive, digital camera, tf card, SD/XD/CF card, USB flash drive, etc.
Supports excel files recovery of Excel 2016, 2013, 2010, or 2007, etc.
Supports over a thousand file formats.
Step 1. 1.Download the program from the website, install it, and launch it. Choose the Deleted Files Recovery option from the main menu.
Step 2. Select the location where the excel file is stored and hit the next button.
Step 3.You will be asked to select a file type, choose documents and hit the scan button. Wait for the scanning process to finish.
Step 4. Preview the files from the scanning results and select which ones you want to recover. Hit the recover button when you are ready.
If you find that your excel files are constantly giving you the “excel cannot open the file” error, or you need to constantly modify/change the file extension, consider turning on the AutoSave feature. To do this, open your Excel program and his the save button in the file menu. Under the Save Workbooks section, find the “Save AutoRecover Information” option and the “Keep the Last AutoSaved Version When I Close Without Saving”, and check mark both boxes. Other than this, create backups, make sure that you do not have viruses or malware, and always save the document with a unique file name.
By Simon Marcus , to Document Recovery
Posted on Nov 29, 2019 ( Updated: Dec 16, 2019 )