Excel xp damaged file three strokes first aid

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.