Excel cannot open the file "filename.xlsx" because the file format or tệp tin extension is not valid. Verify that the tệp tin has not been corrupted and that the tệp tin extension matches the format of the file. Bạn đang xem: Excel cannot open a file? try these 4 methods!
You tried lớn open an Excel tệp tin in Windows 10 but found that it couldn’t be opened and reported the above sầu error message? There are many reasons for this problem, such as tệp tin extension incompatibility with Excel version, file format corruption & so on. This page shows you several comtháng and effective sầu solutions to lớn fix the “Excel cannot open the file because the extension is not valid” error và ensure that you can open the problematic Excel file without losing data.
5 ways khổng lồ fix "Excel cannot open the file"
Way 1: Change the tệp tin extension
A mismatch between the file extension & your current Excel version may cause the error “Excel cannot open the tệp tin because the file format of file extension is not valid”. So, it is advised khổng lồ check the file extension first while dealing with this error.
1. Open File Explorer in your Windows 10 và navigate to the Excel tệp tin that cannot be opened.
2. Select the View tab & make sure the ‘File name extensions’ check box is checked. Then kiểm tra the file extension of the Excel tệp tin. Make sure its tệp tin extension is .xlsx or .xls.
3. If the tệp tin extension is .xls, change it to .xlsx. If the tệp tin extension is .xlsx, change it lớn .xls. Then check if you can open this Excel file successfully. If you’re sure that the file extension is not the problem, read on.
Way 2: Change the file permission
The reason for the error “Excel cannot open the tệp tin because the file format or file extension is not valid” may also be that you vì not have permission to lớn open the Excel file. In this case, changing the tệp tin permission will solve sầu this problem.
Step 1: Right click the Excel tệp tin that cannot be opened, & then select Properties from the context menu.
Step 2: When the file’s Properties dialog opens, select the Security tab và cliông chồng Edit. When the Permissions dialog opens, click the Add button.
Step 3: When the Select Users or Groups dialog opens, clichồng Advanced. When the next dialog opens, cliông chồng Find Now, select Everyone from the search results các mục, & then clichồng OK.
Step 4: When you return to the Permissions dialog, you will see that the Everyone group has been added khổng lồ the group or user danh sách. Select the Everyone group, check all checkboxes under Allow, & then cliông xã Apply.
That’s it. Now kiểm tra 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 file extension is not valid or the tệp tin is corrupted. It may just a protection measure in the Excel program khổng lồ prsự kiện opening potentially dangerous files. If so, disabling Protected View in the Excel program should fix the error.
Step 1: mở cửa any excel tệp tin that can be opened. Then cliông chồng the File tab and select Options.
Step 2: After the Excel Options window opens, cliông chồng Trust Center in the left pane, và then cliông xã 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 xã OK.
Xem thêm: Du Học Hàn Quốc Có Tốt Không, Du Học Hàn Quốc Có Khó Như Bạn Nghĩ Hay Không
Step 4: Now check if you can successfully open the Excel file that reported the error “Excel cannot open the tệp tin because the file format or tệp tin extension is not valid.”
Way 4: Use "Open & Repair" in Excel
If you have sầu tried the above sầu methods, but the ‘Excel cannot open the file’ error persists, it is likely that the file format is indeed corrupted. Now, try the ‘xuất hiện and Repair’ feature built in the Excel program to lớn repair the tệp tin.
Step 1: Type excel in the taskbar tìm kiếm box & hit Enter to lớn open the Excel app.
Step 2: Cliông xã Open và under the Open section, click Browse.
Step 3: After the xuất hiện dialog opens, navigate lớn the excel tệp tin that cannot be opened và select it. Click the arrow next khổng lồ the xuất hiện button, and then select ‘xuất hiện & Repair’ from the drop-down danh sách.
Step 4: When a warning dialog opens, clichồng Repair.
Step 5: Once the Excel file is repaired, it will be opened automatically with a prompt dialog. Click Cthất bại khổng lồ cthua thảm the prompt dialog.
Step 6: Cliông chồng File > Save As to lớn save sầu the repaired Excel file with a different name or khổng lồ a different location.
Way 5: Fix the Excel file with balkanpoliticalclub.net Excel Refixer
If unfortunately, none of the above sầu methods work for you, try lớn use a professional Excel tệp tin repair tool to lớn fix & open your Excel tệp tin. balkanpoliticalclub.net Excel Refixer is one such tool that helps fix Excel files that refuse khổng lồ open due to any error or corruption. Follow these steps.
Step 1: Download & install balkanpoliticalclub.net Excel Refixer on your PC. After installation, launch this tool.
Step 2: Cliông xã the plus button on the main interface. When a dialog opens, navigate khổng lồ the corrupted or problematic Excel tệp tin that cannot be opened, select it, và then clichồng Open. The Excel tệp tin will be added lớn the tool.
Step 3: Cliông xã Restore in the lower left corner. The software will immediately start repairing the Excel file.
Step 4: Once the file is repaired successfully, you will get a prompt dialog on the screen. Cliông xã OK to lớn finish.
Step 5: Finally, clichồng Save to save sầu the repaired Excel file with a different name or to lớn a different location. Once the file 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 file without any problem.