HomeĐời SốngExcel cannot be open the file "filename

Excel cannot be open the file "filename

11:34, 12/04/2021

Excel cannot open the tệp tin "filename.xlsx" because the tệp tin format or tệp tin extension is not valid. Verify that the tệp tin has not been corrupted & that the tệp tin extension matches the format of the tệp tin.

Bạn đang xem: Excel cannot be open the file "filename

*

You tried to open an Excel file in Windows 10 but found that it couldn’t be opened & reported the above error message? There are many reasons for this problem, such as tệp tin extension incompatibility with Excel version, file format corruption và so on. This page shows you several comtháng & effective solutions lớn fix the “Excel cannot open the file because the extension is not valid” error and ensure that you can open the problematic Excel tệp tin without losing data.

5 ways to fix "Excel cannot open the file"

Way 1: Change the file extension

A mismatch between the file extension and your current Excel version may cause the error “Excel cannot open the file because the file format of file extension is not valid”. So, it is advised to lớn check the tệp tin extension first while dealing with this error.

1. xuất hiện File Explorer in your Windows 10 & navigate to the Excel file that cannot be opened.

2. Select the View tab and make sure the ‘File name extensions’ check box is checked. Then kiểm tra the tệp tin extension of the Excel file. Make sure its tệp tin extension is .xlsx or .xls.

*

3. If the file extension is .xls, change it khổng lồ .xlsx. If the file extension is .xlsx, change it to .xls. Then kiểm tra if you can open this Excel file successfully. If you’re sure that the tệp tin extension is not the problem, read on.

Way 2: Change the file permission

The reason for the error “Excel cannot open the file because the tệp tin format or tệp tin extension is not valid” may also be that you do not have permission to lớn open the Excel file. In this case, changing the tệp tin permission will solve this problem.

Step 1: Right click the Excel file that cannot be opened, & then select Properties from the context menu.

*

Step 2: When the file’s Properties dialog opens, select the Security tab & cliông chồng Edit. When the Permissions dialog opens, cliông chồng the Add button.

*

Step 3: When the Select Users or Groups dialog opens, cliông xã Advanced. When the next dialog opens, cliông chồng Find Now, select Everyone from the tìm kiếm results danh sách, and then clichồng OK.

*

Step 4: When you return to lớn the Permissions dialog, you will see that the Everyone group has been added khổng lồ the group or user các mục. Select the Everyone group, check all checkboxes under Allow, and then clichồng Apply.

*

That’s it. Now check if you can open this Excel file successfully.

Way 3: Disable Protected View

Sometimes, the error “Excel cannot open the file” does not really mean the tệp tin extension is not valid or the tệp tin is corrupted. It may just a protection measure in the Excel program lớn prevent opening potentially dangerous files. If so, disabling Protected View in the Excel program should fix the error.

Step 1: mở cửa any excel file that can be opened. Then click the File tab & select Options.

*

Step 2: After the Excel Options window opens, clichồng Trust Center in the left pane, & then cliông chồng Trust Center Settings in the right pane.

*

Step 3: After the Trust Center window opens, select Protected View in the left pane, uncheck the three kiểm tra boxes under the Protected View in the right pane, và then cliông chồng OK.

Xem thêm: Doll Là Gì - (Từ Điển Anh

*

Step 4: Now check if you can successfully open the Excel tệp tin that reported the error “Excel cannot open the tệp tin because the tệp tin format or tệp tin extension is not valid.”

Way 4: Use "xuất hiện và Repair" in Excel

If you have tried the above methods, but the ‘Excel cannot open the file’ error persists, it is likely that the tệp tin format is indeed corrupted. Now, try the ‘Open & Repair’ feature built in the Excel program lớn repair the file.

Step 1: Type excel in the taskbar search box và hit Enter to open the Excel tiện ích.

Step 2: Cliông chồng Open và under the xuất hiện section, clichồng Browse.

*

Step 3: After the Open dialog opens, navigate to the excel file that cannot be opened & select it. Cliông xã the arrow next to the mở cửa button, & then select ‘Open & Repair’ from the drop-down list.

*

Step 4: When a warning dialog opens, cliông chồng Repair.

*

Step 5: Once the Excel tệp tin is repaired, it will be opened automatically with a prompt dialog. Cliông chồng Close to close the prompt dialog.

*

Step 6: Cliông xã File > Save sầu As to lớn save the repaired Excel tệp tin with a different name or lớn a different location.

Way 5: Fix the Excel tệp tin with aiesec-unwe.net Excel Refixer

If unfortunately, none of the above sầu methods work for you, try khổng lồ use a professional Excel tệp tin repair tool to fix and open your Excel file. aiesec-unwe.net Excel Refixer is one such tool that helps fix Excel files that refuse to open due to any error or corruption. Follow these steps.

Step 1: Download và install aiesec-unwe.net Excel Refixer on your PC. After installation, launch this tool.

Step 2: Click the plus button on the main interface. When a dialog opens, navigate lớn the corrupted or problematic Excel tệp tin that cannot be opened, select it, và then cliông xã mở cửa. The Excel file will be added lớn the tool.

*

Step 3: Clichồng Restore in the lower left corner. The software will immediately start repairing the Excel tệp tin.

*

Step 4: Once the tệp tin is repaired successfully, you will get a prompt dialog on the screen. Cliông chồng OK to lớn finish.

Xem thêm: Điểm Chất Lượng Tối Ưu Là Gì ? 3 Cách Tối Ưu Điểm Chất Lượng Từ Khóa

*

Step 5: Finally, clichồng Save lớn save sầu the repaired Excel tệp tin with a different name or to lớn a different location. Once the tệp tin is saved successfully, the problem “Excel cannot open the tệp tin because the tệp tin format or tệp tin extension is not valid” is resolved. You can open the repaired Excel tệp tin without any problem.


Chuyên mục: Đời Sống