How to fix the error can not open Excel files

Download the Excel file online or copy the Excel file from your friend's computer to your computer. But when you open it, it cannot open, you are not sure how to fix the error of not opening Excel file? Invite you to refer to the way that the tutorial article below.

How to fix the error can not open Excel files Picture 1

Here are ways to fix the error of not opening Excel file, please follow along.

1. Format error

If you open and see the error message "Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid . ' then it means your version of Excel is lower than the version The file has been created because the new .xls file can be opened in lower versions of Excel.

How to fix the error can not open Excel files Picture 2

To open the .xlsx format, you need to install newer versions such as Office 2010, 2013 or 2016 to be able to easily open the file. Or you can change the file format from .xlsx to .xls by pressing F2 to rename then you change the format to .xls and press Enter

How to fix the error can not open Excel files Picture 3

The message appears Are you sure you want to change it? (Are you sure you want to change?) Select Yes .

How to fix the error can not open Excel files Picture 4

So you can open the file on any version of Excel.

2. Use the Open and Repair feature

Step 1 : Open a new Excel file, on the interface, select File -> Open -> Browse.

How to fix the error can not open Excel files Picture 5

Step 2: Open the dialog box you navigate and select the Excel file you want to recover. Next, select the triangle icon next to Open and choose Open and Repair.

How to fix the error can not open Excel files Picture 6

Step 3: A Microsoft Excel message box appears, select Repair to repair the file.

How to fix the error can not open Excel files Picture 7

If in case that Repair is not possible, you perform again and select Extract Data to extract data.

How to fix the error can not open Excel files Picture 8

3. Set the calculation options in Excel to manual

To open the workbook, try changing the calculation settings from automatic to manual, because the workbook will not be recalculated so it can be opened. You do the following:

Step 1 : Open a new Excel file, on the interface, select File -> Options (for Excel 2010, 2013, 2016).

How to fix the error can not open Excel files Picture 9

Step 2 : On the Excel Options window, select Formulas , in the Workbook Calculation section, select Manual and then OK to save.

How to fix the error can not open Excel files Picture 10

Step 3 : Choose File -> Open -> Browse and select the Excel file to open to open it.

How to fix the error can not open Excel files Picture 11

Chances are you will be able to open the Excel file after doing this way.

4. Use Easy Office Recovery software

You need to visit https://www.munsoft.com/EasyOfficeRecovery/ to download and install Easy Office Recovery software.

Step 1 : Open Easy Office Recovery software, on the interface, select File -> Open data file.

How to fix the error can not open Excel files Picture 12

A new window appears, select Open File and navigate and select the Excel file to fix.

How to fix the error can not open Excel files Picture 13

Step 2 : The Excel file will be displayed in the interface, to recover the file, click File -> Recover data.

How to fix the error can not open Excel files Picture 14

Step 3 : Click Browse to select the folder to save the Excel file after recovery and click Next .

How to fix the error can not open Excel files Picture 15

The message Files were successfully recovered appears that you have successfully recovered the corrupted Excel file. You try to open the folder containing the Excel file after recovering and open the file to see the results.

Above are ways to fix the error of not opening Excel file, hopefully with the ways that the article shared above, you can fix Excel file error. Good luck!