What About Word Code?

1, conversion format method

This method is to damage the damage. Excel Workbook Save it again, and save the format in SYLK format; in general, if you can open it up, it will be damaged. Excel file If you can't edit and print files, then I suggest that you first try this method to convert the damaged Excel workbook into SYLK format to save the damaged part of the document.

2, direct repair method

The latest version of Excel has direct repair. Damaged file Function, you can use Excel's new "open and repair" command to directly check and repair errors in the Excel file. If you click the command, Excel will open a repair dialog box and click the repair button in the dialog box. This method is often suitable for using conventional methods to not open damaged files.

3, the law of fraud

When you can't open the damaged Excel file, you can try to use the Word program to open the Excel file. This method is implemented by Word directly reading the Excel file function. It is usually applied to the case where the Excel file header is not damaged.

(1) run the Word program and select the Excel file that needs to be opened in the open file dialog box.

(2) if you first use the Word program to open the Excel file, you may see that "Microsoft Word cannot import the specified format. This function is not installed at the moment, is it installed now? "At this time, you can insert the Microsoft Office installation disk to complete the installation task of the function.

(3) next, the Word program will tell you whether you choose the whole workbook or a worksheet. You can choose from the type of file you want to restore.

(4) once the damaged file is opened, the damaged data in the file can be deleted first, then the mouse is moved to the form, and the form "conversion" / "form conversion to text" order is executed successively in the menu bar.

(5) in the subsequent dialog box, select tabs as text separator to convert the table content into text content.

(6) in the Word menu bar, execute the "file" / "save as" command in turn, and save the converted text content as plain text file.

(7) run the Excel program to execute the "file" / "open" command, select the text type as "text file" or "all files" in the pop-up file dialog box, so that the newly saved text file can be opened.

(8) then you will see a text Import Wizard settings box, you can just open the file according to the prompt, so you will find that the content of the worksheet is exactly the same as the original worksheet. The difference is that all the formulas in the form need to be reset, and some text and number formats are missing.

4, auto repair method

If the Excel program runs malfunction and the file is damaged, you can use this repair method. Once the Excel program stops responding during the editing process, you can force the program to close. If the file is damaged due to a sudden power failure, you can restart the computer and run Excel, so that Excel will automatically pop up the "document recovery" window, and lists all files that Excel Excel automatically recovered when the program happened. You can use the mouse to select every file that you want to retain, click the arrow next to the specified file name, and then follow the following steps to manipulate the file:

(1) if you want to re edit the damaged file, you can edit it directly by clicking the "open" command.

(2) if you want to save the damaged file, you can click "save as", enter the concrete name of the file in the saved file dialog box, and save the file in the old folder in the default state.

(3) if you want to view the damaged repair information, you can click the display repair command directly.

(4) after you have completed the operation of all the files you want to retain, you can click the "close" button in the document recovery task pane.

The Excel program does not enable automatic repair function in default state. Therefore, we hope that Excel can automatically restore files outside of other situations. We must also open the automatic recovery function according to the following steps:

(1) in the menu bar, execute the "tool" / "option" command in turn to open the options settings box.

(2) click the "save" tab in the settings box and cancel the "auto restore" check box on the subsequent tab page.

(3) select the "save automatic recovery information, every X minutes" check item in the tag page, and enter the specified Excel program to save the frequency of automatic recovery files.

(4) after completing the setup, click the "confirm" button to exit the setup dialog.