Excel damaged file First Aid six strokes

Excelxp file is damaged, then you are to discard the damaged file, or to find a way to first aid it? If it belongs to the latter type, 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 saved format as the SYLK format; In general, if you can open the damaged Excelxp file, just can't do various editing and printing of the file, 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 damaged Excelxp file, you can try to open the Excel file using Word, which is implemented directly by using Word to read the Excel file feature, which is usually true for Excelxp file headers that are not corrupted. The following is a specific procedure:





(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 use a Word program to open a EXCELXP 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? ", you can plug in the Microsoft Office installation disk to complete the installation task for 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, move the mouse to the table, and then execute the form/convert/table to text command in the menu bar;





(5) In the dialog box that appears, select the tab character as the text separator to convert the table contents to text content;





(6) In the Word menu bar, follow the "file"/"Save As" command, and save the converted text into a plain text format file;





(7) runs the EXCELXP program to execute the "file"/"Open" command, select text type as "text file" or "All file" in the pop-up file dialog box, so that you can open the text file you just saved;





(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, and click the arrow next to the specified filename, and then follow the steps below to manipulate the file:





(1) If you want to edit a 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 to enter the specific name of the file in the File Save dialog box that appears; The program saves the file in the previous folder by default;





(3) If you want to view file damage repair information, you can click the show Repair command directly;





(4) You can click the Close button in the Document Recovery task pane after you have completed all the files associated with the file you want to keep:





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) To open the option settings box by executing the Tools/Options command in the menu bar;





(2) Click the Save tab in the Settings box and cancel the Disable AutoRecover check box on the tab page that is opened subsequently;





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





(4) When you have finished setting up, click OK to exit the Setup dialog box.