What if the Excel table doesn't open?

What if the Excel table doesn't open?

1, first of all we need to confirm whether this Excel form is a real Excel form, many friends will ask, Excel forms also have true and false points, the answer is yes, there, the so-called false is not originally Excel table, forced to change the suffix after making it disguised as a form, For example, the small set of a new WPS file forced to change the suffix called Excel file, opened will be prompted as shown in the following image, want to open such a file, you must know its original format, and then restore the suffix, using the relevant software to open it.

2. Although Excel 2003 is still used by many people, with the advent of versions 2007 and 2010, Excel files have one more format than the xlsx format, which is the suffix name of the file created by 2007 and 2010, and 2003 is not open. If you want to open this format of the Excel file a lot of ways, we can download the Compatibility Pack, you can upgrade the Excel software to 2007 or 2010, can open the end of the xlsx suffix of the Excel file.

3, if the confirmation of the Excel form is true, and also is not a version of the problem, it is possible that the problem of Excel software, is now a viral epidemic of the era, as long as the internet can be toxic, so we want to confirm whether the virus destroyed our Excel software, resulting in software does not work properly, Carry out the whole virus killing, see whether can solve the problem, the virus killing in safe mode effect will be better.

4, if still can not solve the problem, it is likely that the virus or other operations damaged the components of the Excel software, at this time we can uninstall the existing Excel software, and then download the latest Excel software on the official web to install, and then try to open the Excel file to see.

5, if not solve the problem, it is likely that the problem is not out of the software, but the file itself may be corrupted. We can try to fix this file. We open the software, then find the file, click on the Open option, find the Excel file we need to open, remember to click to select, do not double-click to open, and then click on the black triangle that opens the button, find the open and Repair option in the Drop-down box that appears, and then click.

6, at this time will pop up a repair confirmation box, let us carry on the repair choice, if is wants to recover as much work, click the Repair option, if just wants to extract the data, clicks extracts the data option, as far as chooses which kind of repair method, also needs the user to choose according to own situation

7, of course, there is also a possible Excel file is encrypted, encrypted Excel file can only be accessed by entering a password, currently according to the small part of the know no other way, if you really want to open the encrypted file, you can go to the download to find the person uploading this file, let him tell you the password.

Attention matters

Now the network is full of false, even the file suffix will be fake, for how to determine whether the real Excel file small series and there is no better way, can only be judged by experience.

Version is also very easy to ignore a problem, before opening the file we have to look at the suffix name, if it is xlsx suffix of the file requires us to download a high version of the Excel software, of course, if you often use Excel files, we suggest you always update the software to the latest version, so, Any Excel file can be opened, but you can also use WPS.