Sometimes you open a previously edited Excel workbook, but found the content of confusion, unable to continue editing, it is not able to print. Many friends in dealing with this Excel file are likely to encounter a problem, the face of this situation, how should we do then? The above cases the reason should be that the file is already damaged the, At this point you may wish to try I used to tell you about the following approach may help you to excel file repair (in Excel2003 example).
1, excel file repair is going to save the workbook as SYLK format
If the Excel file can be opened, then the workbook into SYLK format can filter out the damaged part of the document and then save the data.
First, open the required workbook. In the "File" menu, click "save as" command. In the "Save as type" list, click the "SYLK (symbolic link) (*. slk)" option, then click the "Save" button. Close the current open file, open the can just save the SYLK version.
Second, excel file repair conversion to an earlier version
If the startup failure because Excel does not save the workbook, the last saved version may not be damaged. Of course, this version does not include the last time the document after saving changes made.
Close the open workbook, when the system asks whether to save changes, click "no." In the "File" menu, click "Open" command, double-click the workbook files.
3, excel file repair and restoration of open workbook
If the Excel file to use the conventional method does not open, you can try Excel2003 in the "Open and Repair" feature that can check and fix errors in Excel workbook.
In the "File" menu, click "Open" command. Through the "Look in" box, locate and open the folder that contains the damaged document, choose to restore files. Click "Open" button next to the arrow, and then click "Open and Repair" button.
4, excel file repair Excel viewer used to open the workbook
Still in use every means to solve the problem of the case, we may wish to consider using third-party software to carry out restoration work.
Excel viewer is used to view Excel workbook free utility can be obtained from the Microsoft Web site, the latest version ExcelViewer2003.
Double click the downloaded file xlviewer.exe start the installer, then follow the instructions to complete the installation. Installation is complete, click "Start" menu "MicrosoftOfficeExcelViewer2003" you can start the software, try to open the damaged workbook. We can open the corrupted in the program workbook, and then copy the cells and paste them into a new Excel workbook. If you later want to remove Excel viewer is available through "Control Panel" in the "Add / Remove Programs" to remove.
I hope the above methods can help you to excel file repair. If you can not restore data from damaged workbooks, you need to re-create a part or the entire document.