Despite the increasing challenges from competitors like Google Sheets, Microsoft Excel remains the most used spreadsheet app. It’s the tiện ích of choice in most workplace settings. What’s more, it includes numerous tools that help streamline & ease workflows.

Bạn đang xem:

Excel, lượt thích every other Microsoft app, occasionally runs into issues. Most of these are mere annoyances và can be solved with one or two program or system reboots. However, the “Excel cannot open the file because the tệp tin format or extension is not valid” issue has proved to lớn be more bothersome for several users.

If you encounter this message when you try to open a tệp tin in Excel (or an Excel file), this guide will be helpful. We explain the possible reasons why the error can occur and three solutions that could work for you.

Excel Cannot open the tệp tin Because the file Format or tệp tin Extension Is not Valid


When any user encounters this error in Excel, it’s usually due to lớn one of two reasons:

The tệp tin is corrupted.The tệp tin extension isn’t supported.

A corrupted file is unlikely to lớn be opened by the parent program. Even if it successfully opens, it’s likely to have multiple errors such as missing data or unreadable portions. Excel và several other programs go the extra mile and simply don’t open corrupted files. It’s up lớn the user lớn try và fix the file corruption first or use another document with uncorrupted data.

Sometimes, the corruption is caused by malware that infiltrated the system. This can happen if your system isn’t fully protected when working with Spreadsheets on the web. Unrelated internet activity can cause this as well. After all, some malware types are known khổng lồ be distributed as macros that can attach khổng lồ Office documents.

It is better to be prepared for anything. gameviethot.com Anti-Malware will protect you against online and offline threats, as your main or supplementary antivirus. It’s unobtrusive, lightweight, fast, và frequently updated.


RECOMMENDED
*
Protect PC from Threats with Anti-Malware

Check your PC for malware your antivirus may miss and get threats safely removed with gameviethot.com Anti-Malware


*

download NOW

Sometimes, this error could be due to incompatible or unsupported file formats. Versions of Excel since 2007 use Office mở cửa XML as the primary file format but are backward-compatible with the earlier versions of Excel files. A glance at the tệp tin extension will tell you straight away whether the program can mở cửa that file.

If the tệp tin you’re attempting to xuất hiện is in one of these formats, it won’t mở cửa because it’s been corrupted. That’s because the file extension is compatible with Excel:

Excel Workbook. Xlsx

Excel Macro-enabled Workbook. Xlsm

Excel Binary Workbook. Xlsb

Excel Macro-enabled Template. Xltm

Excel Add-in. Xlam

Spreadsheet. Xls

Excel Template. Xlt

Excel Macro. Xlm

In addition, documents in these non-Excel file extensions can be opened by the program, though functionality might be reduced in some fashion:

XML. Spreadsheet 2003 or XML formatted files. Xml

Lotus Spreadsheets. Prn

Tab delimited/Unicode text files. Txt

Comma-separated values files. Csv

Data Interchange Format files. Dif

Symbolic liên kết Format text files. Slk

dBase Data Files. Dbf

OpenOffice Files. Ods

XML Paper Specification Files. Xps

Portable Document Format files. Pdf

Note that this isn’t an exhaustive list. Excel can mở cửa files with other extensions, including html.

How to lớn Fix the “Excel Cannot open the tệp tin Because the tệp tin Format or tệp tin Extension Is not Valid” Issue on Windows 10

Sometimes, when opening a tệp tin in Excel, the program displays this error message instead:

Microsoft Excel

Excel cannot open the tệp tin because the file format or file extension is not valid. Verify that the file has not been corrupted và that the file extension matches the format of the file.

If you encounter this error in any version of Excel since Excel 2007, three options are open to you:

Check the file extension and change it if needed.Repair the file with Excel’s inbuilt repair tool.Change group permissions for the file.

Let’s explain each option in more detail.

Xem thêm: Cách Làm Wifi Mạnh Hơn Cho Điện Thoại, Tăng Tốc Độ Wifi Cho Android

Solution 1. Check the tệp tin Extension

If you’re unable to open the file, it could be due khổng lồ an unsupported file extension. Khổng lồ be frank, this is very rare nowadays since most spreadsheets use a format Excel can open. However, if you’re trying to xuất hiện the document on a pre-2007 Excel program, you can have issues with certain files.

There are two scenarios here:

The Excel file is not opening in a legacy version of the program.The tệp tin is not opening in Excel because of an unsupported format.

In both instances, the solution is the same. Open any Excel tệp tin (or just launch the program and mở cửa a blank spreadsheet) and click the file tab. Next, click mở cửa > Browse và locate the file you’re trying khổng lồ open.

Now, look under the tệp tin name field and change the file extension. If you’re trying to mở cửa an xlsx document in a legacy Excel version, change the extension to lớn xls. If you’re trying to open a document in an unsupported or less common file format, change the extension to lớn xlsx or xls.

Save the change và then try opening the file again. If everything is done right, the tệp tin should xuất hiện now.

Solution 2. Repair the File

When you get the “Excel cannot xuất hiện the tệp tin because the file format or tệp tin extension is not valid” error, it’s likely because the spreadsheet is corrupt. If you manage to open the tệp tin anyway, there might be multiple errors và we’re sure you don’t want that. It is better khổng lồ try repairing the file first và that is exactly what we’re going to do.

Open a blank spreadsheet in Excel.Select the tệp tin tab and click Open.Hit the Browse button và choose the problematic file.In the file selection window, click the mở cửa drop-down menu and select xuất hiện and Repair.

Excel will attempt khổng lồ repair the file and then xuất hiện it.

Solution 3. Change Group Permissions

In rare instances, the “Excel cannot open the file because the tệp tin format or tệp tin extension is not valid” error happened because the file has special permissions. Removing this permission will allow your Excel program to open it without issues.

Here are the steps to try:

Navigate khổng lồ the location of the problematic file.Right-click the file & select Properties.When the Properties dialog box opens, switch lớn the Security tab.In the Security tab, click the Edit button to lớn change permissions got for the file.A new Permissions dialog box will open. Locate and click the add button.Another dialog box will mở cửa labeled “Select Users or Groups”. In this box, click the Advanced button.Click the Find Now button.Select Everyone under the tìm kiếm results & then click OK.Click the OK button again lớn return to the Permissions dialog box. You’ll notice that the Everyone group has been added lớn the menu under “Groups or user names”.Select Everyone in the “Groups or user names” section.Under Permissions for Everyone, tick Allow for all the options.Click Apply & then OK to confirm and save your changes.

After this, the tệp tin will no longer be restricted and you should be able to xuất hiện it in Excel.