Four ways to save Excel form corruption

No matter what software, it is inevitable that the fate of the damage, Excel is the same, but, when Excel damaged, how should we do it? is to allow its development, or to repair self-help methods, of course, we will choose the latter, to repair self-help methods, but, in the end there are several ways to save themselves? Now the word union has listed 4 kinds of better methods, hope to help everyone.

　The first approach: take a direct fix

The latest version of Excel has the ability to directly repair damaged files, and you can use the new open and Repair command in Excel to directly check for and fix errors in Excel files, as long as

When you click the command, Excel opens a repair dialog box and clicks the Repair button in the dialog box. This approach is often suitable for situations where a corrupted file cannot be opened with a normal method.

　The second method: use Word to take the wrong cue to guide the correct installation method

When you encounter an inability to open a damaged Excel file, you can try using a Word program to open an Excel file, which is implemented by using Word to read the Excel file feature directly, which is usually true for Excel file headers that are not corrupted, and the following steps are specific:

1, run the Word program, in the file opened dialog box to select the need to open the Excel file;

2. If you use a Word program to open an Excel file for the first time, you may see that Microsoft Word cannot import the specified format. This feature is not currently installed, do you want to install it now? " Prompt, you can insert the Microsoft Office installation disk to complete the installation of this feature;

3, then the Word program will prompt everyone, is to select the entire workbook or a worksheet, you can restore according to the type of file to choose;

4, once the damaged file opened, you can first delete the corrupted data in the file, and then move the mouse to the table, and then in the menu bar to execute the "form"/"Conversion"/"Table converted to text" command;

5, in the subsequent dialog box to select the tab character for the text separator, to convert the contents of the table to text content;

6, in the Word menu bar in order to execute the "file"/"Save As" command, the conversion obtained text content saved as plain text format file;

7, run the Excel program, to execute the "file"/"open" command, in the pop-up file dialog box text type selected as "text file" or "All Files", so you can open just saved text file;

8, then you will see a Text Import Wizard Settings box, as long as you can easily open the file according to the prompts, so that everyone will find that the worksheet content is exactly the same as the original worksheet, the difference is that all the formulas in the table need to be reset, and some text, the number format is missing.

　　The third method: take the format of conversion

This method is to save the damaged Excel workbook and select the saved format as SYLK format; In general, if you can open a damaged Excel file, you just can't enter the file

All kinds of editing and printing operations, then the Word federation recommends that you try this to save a damaged Excel workbook by converting it to the SYLK format, which filters out the

Damaged part.

　　The last method: using the software characteristics, self-repairing

You can use this fix if the Excel program fails and the file is compromised. Once the Excel program stops responding in the process of editing a file, you can

Force close the program; If the file is damaged by a sudden power outage, you can restart your computer and run Excel so that Excel automatically pops up the Document recovery window and lists

All files that Excel has automatically recovered when an unexpected reason has occurred to the program. You can use the mouse to select each file to keep, click the arrow next to the specified filename, and then follow the steps below to manipulate the file:

1, if you want to edit the damaged file, you can directly click the "Open" command to edit;

2. If you want to save the damaged file, you can click Save As to enter the file name in the File Save dialog box; The program saves the file in the previous folder by default;

3, if you want to see file damage repair information, you can directly click the "Show Repair" command;

4, after the completion of all the files to be retained related operations, you can click the Document Recovery task pane in the "Close" button;

Excel programs do not have automatic repair enabled by default, so you want Excel to automatically recover files when they occur, and you must follow these steps to turn on the AutoRecover feature:

5, in the menu bar to execute the "tools"/"Options" command, to open the option settings box;

6. Click the "Save" tab in the Settings box and cancel the "Disable AutoRecover" check box on the tab page that opens later;

7, select the tab page "Save AutoRecover information, every x minutes" complex options, and enter the specified Excel program to save the frequency of automatic recovery files;

8, after the setup, click "OK" button to exit the Settings dialog box.

Well, the above is 4 kinds of Excel damaged after the repair method, I hope that the work of everyone has a certain degree of help.