Excel damaged file First Aid six strokes

The heart, careful, again careful, but still can not avoid EXCELXP file is damaged, that you will be damaged file abandoned, or find a way to first aid? If the latter type is the case, you will be pleasantly surprised by the content below.

1. Conversion Format method

This method is to save the damaged Excelxp workbook and select the save format as the SYLK format; In general, if you can open the damaged Excelxp file, only can not do a variety of editing and printing of files, then I suggest that we first try this method, To save the damaged Excelxp workbook in a SYLK format, which filters out the corrupted parts of the document.

2. Direct Repair method

The latest version of EXCELXP has the ability to directly repair damaged files, you can use the EXCELXP new "Open and Repair" command to directly check and repair errors in the Excelxp file, just click the command, EXCELXP will open a repair dialog box, Click the Repair button in the dialog box to do so. This approach is often suitable for situations where a corrupted file cannot be opened with a normal method.

3. Cynical method

When you encounter an inability to open a corrupted excelxp file, you can try to open the Excel file by using Word, which is implemented directly by using Word to read the Excel file feature, and is typically applied to situations where the header of the Excelxp file is not corrupted, and the following steps are specific:

(1) Run the Word program and select the Excel file you want to open in the File Open dialog box that appears;

(2) If you first use a Word program to open a EXCELXP file, 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 is opened, you can delete the corrupted data in the file, then move the mouse to the table, and then execute the "form"/"Convert"/"form to Text" command in the menu bar;

(5) Select the tab character as the text separator in the subsequent dialog box to convert the table contents to text content;

(6) In the Word menu bar to execute the "file"/"Save As" command, the conversion obtained text content saved as a plain text format file;

(7) Run EXCELXP program to execute "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.

4, automatic repair method

You can use this fix if the EXCELXP program fails and the file is compromised. Once in the process of editing a file, the EXCELXP program stops responding, you can force the shutdown program; If the file is damaged by a sudden power outage, you can restart your computer and run Excelxp so that excelxp automatically pops up the Document Recovery window. This window lists all the files that Excelxp have automatically recovered when the program has an unexpected cause. 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 edit it directly by clicking on the "Open" command;

(2) If you want to save the damaged file, you can click Save As to enter the name of the file in the File Save dialog box that appears, and in the default state, save the file in the previous folder;

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

(4) After you have completed the operation of all the files that you want to keep, you can click the Close button in the Document Recovery task pane.

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

(1) In the menu bar to execute the "tools"/"Options" command, to open the option settings box;

(2) Click the Save tab in the Settings box and cancel the "Disable AutoRecover" checkbox in the subsequent Open tab page;

(3) Select the "Save AutoRecover information, every x minutes" option in the tab page and enter the frequency of the specified Excel program to save the AutoRecover file;

(4) When the settings are complete, click OK to exit the Setup dialog box.