Lỗi excel cannot open the file because the file format or file extension is not valid

Summary: This post discusses workarounds to resolve sầu the ‘Excel cannot open the tệp tin because the extension is not valid’ error. The error may occur if you’re using an unsupported Excel file format or the tệp tin is corrupt. If the Excel tệp tin is severely corrupt, you can use an Excel repair tool to fix it and recover the data.

Bạn đang xem: Lỗi excel cannot open the file because the file format or file extension is not valid

When opening an older version of an Excel tệp tin in a newer version, you may encounter the “Excel cannot open the file because the extension is not valid” error. This happens if you have accidentally renamed the file with a different tệp tin format or an incorrect tệp tin extension. Also, you may get the ‘Excel cannot open the file’ error if the file has become unreadable or corrupted.

This is how the complete Excel error message looks like:

“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 và that the tệp tin extension matches the format of the file.”

Check out this đoạn Clip for a quiông xã demonstration of how to fix “Excel Cannot mở cửa the File Because the Extension Is Not Valid”

How to lớn Fix ‘Excel Cannot Open the File Because the Extension Is Not Valid’ Error?

Try any of these workarounds to lớn fix the error & regain access to lớn your Excel tệp tin data:

Workaround 1 – Change the Default File Format

By mặc định, an Excel tệp tin is saved in .xlsx or .xls tệp tin format. Trying lớn open the file with a different or incorrect extension may cause the ‘Excel cannot open the tệp tin because the extension is not valid’ error. To fix the error, try changing the Excel mặc định file format by following these steps:

Note: Take a backup of the Excel file that you cannot open and try the steps on the backup copy.

In Excel 2010 và newer versions, click on the File thực đơn.

Note: For Excel 2007 & earlier versions, cliông xã on the Office button.

In Info screen that appears, clichồng on Options. In ‘Excel Options’ window, under Save sầu workbooks section, click on the Save files in this tệp tin format: drop-down. Select a tệp tin format (i.e., the one supported by your Excel version).Clichồng OK.

Cheông chồng if you can open your Excel tệp tin. If not, try the next workaround.

Workaround 2 – Edit the Excel File Permissions

You may receive sầu the ‘Excel file format or tệp tin extension is not valid’ error if you laông xã sufficient permissions lớn open the tệp tin. Usually this happens when you try lớn open an Excel file received from some other user. Follow these steps khổng lồ change the file permissions và see if it fixes the problem:

Right-cliông xã on the tệp tin that won’t open and click Properties.In the tệp tin properties dialog box, click the Security tab và then hit the Edit button.

When the file’s permissions dialog box appears, cliông xã on the Add button.

Xem thêm: Làm Cách Lấy Số Không Làm Tròn Trong Excel ? Dừng Hiển Thị Số Được Làm Tròn

Clichồng on the Advanced button from the ‘Select Users or Groups’ window.

Excel will danh mục any unsaved files. Try opening the tệp tin và save it. If this doesn’t work, skip khổng lồ the next workaround.

Workaround 4 – Repair the Workbook

If none of the above workarounds has worked for you, chances are that the Excel tệp tin has become corrupted. Try to lớn repair the file using the Excel inbuilt ‘Open & Repair’ utility by following these steps:

In your Excel application, click on File > Open.In the ‘Open’ dialog box that pops-up, select the Excel tệp tin you want to repair & click the arrow next khổng lồ the Open button.From the dropdown list, select mở cửa and Repair.
Excel will ask you to attempt lớn repair the file or extract data from it. Click Repair to retrieve maximum data. If the Repair option fails, click on Extract Data to recover the data without formulas & values.

If the ‘xuất hiện và Repair’ utility doesn’t help fix the corrupted file and/or recover the data, use an Excel repair tool such as Stellar Repair for Excel to regain access lớn your tệp tin and its data.

Stellar Repair for Excel software can help repair severely corrupted XLS & XLSX files. Also, it helps recover all the file components, including tables, pivot tables, cell comments, charts, chart sheets, images, formulas, etc., without impacting the original structure of the Excel tệp tin. 

To learn how the software works, read this: How to lớn repair corrupt Excel tệp tin using Stellar Repair for Excel?

Conclusion

You may encounter the error ‘Excel cannot open the tệp tin because the extension is not valid’ when opening a workbook with a different tệp tin format or an incorrect tệp tin extension. Also, the error may occur if the Excel file has turned corrupt. This article has covered some of the most effective workarounds lớn resolve the error. But if nothing works, you can try lớn repair the Excel file and retrieve sầu its data using the Stellar Repair for Excel software.

FAQs

Q. I have an Excel tệp tin saved on my system. I get the error message ‘Excel cannot open the tệp tin filename.xlsx because the tệp tin format or tệp tin extension is not valid’ when trying to open it. Can I get back all my data using the Excel repair tool?

A. Stellar Repair for Excel displays a pReviews of all the recoverable data. You can get baông chồng all the Excel tệp tin data shown in the pReviews window.

Q. I downloaded the repair tool, but it says, “File is severely corrupted, cannot be previewed.” What should I vì next?

A. This message appears if your Excel file has turned severely corrupt. Liên hệ the tư vấn team at Stellar to lớn get further assistance.