Sihai network

Why can't excel file be opened? How to solve this problem

Four seas entertainment news: there are always people who reflect that the EXCEL form can't be opened, but other excel forms can be opened, which is very depressing, so what should we do if the excel file can't be opened? If the computer is poisoned, it may not only be the EXCEL form file, but also other files, and the virus Different types have different effects.

&Click the next page to view the excel file, which will not open

The reason why excel file can't be opened

Computer poisoning

If the computer is poisoned, the excel file may not be opened. Of course, if it is poisoned, not only the excel file cannot be opened, but also other files can not be opened. Moreover, the effects caused by different types of viruses are different. For example, if the macro virus is used, then the file may not be opened if the macro is not applied Can it have an impact, no matter what, first ensure that the computer is a non-toxic environment can continue to check.

The file is corrupted

If we shut down abnormally, or sometimes other people do not open it normally, for example: using Notepad or other applications to open an excel table file, unfortunately, it is still saved, then the EXCEL form will not be opened, and there is no way to find it back. Therefore, please use the normal corresponding program to open any file.

Not enough disk space

If our computer does not have enough disk space, it is also one of the reasons why excel forms cannot be opened. Generally speaking, when opening any document, we need to create a temporary file. When we open the excel table, we can't open the excel table file because there is no space. Usually, a prompt will appear: "the file may be read-only, or the location you want to access is read-only, or the location you want to access is read-only, or the file location is read-only At this time, the solution is to clear the useless programs and free up the disk space. If not, clear the recycle bin first, and then clear some temporary files. If not, use 360.

Version incompatibility

There is also a reason that the EXCEL form cannot be opened. It may be that your excel version is too low. In this case, the other party sends the excel file to you. However, the version of Excel installed on your computer is too low and the version of the other party is too high. This will also cause the EXCEL form not to be opened. To solve this problem, one is to install the latest version of Excel, and another method is to use the Internet On the online version conversion, of course, you let the other side save as a lower version of Excel spreadsheet file can also solve.

What to do if excel file can't be opened

Method 1

1. Enter excel first, and then use the open menu item. In the open dialog box, select open and repair (click the open button) to try

2. Data -- import external data -- import data, and then follow the prompts, and then save it as an XLS file in Excel.

Method 2

Case 1: an excel file cannot be opened, and the main EXCEL program can be opened.

Solution: open the Excel software and click the 'file' button in the figure to pop up the menu bar.

Select the options card in the menu bar and click open.

Click the 'advanced' button under the tab, and find the 'general' part in the pop-up content, and remove the check in the small box before 'ignore other applications using dynamic data exchange (DDE) ".

Case 2: the new EXCEL file can be opened normally after saving, but the previous excel file cannot be opened.

Solution: open excel and click the open button in the upper left corner of the page.

In the pop-up 'open' dialog box, select the excel file that cannot be opened, and then click the drop-down arrow next to 'open' in the lower right corner, and select 'open and repair'.