Sometimes you open a previously edited Excel workbook, but you find that the content is confusing, that you cannot continue editing, and that you are not ready to print. This is a lot of friends in the processing of Excel files may encounter a problem, in the face of this situation, we should do? The reason for this should be that the file has been corrupted, at this time you may wish to try to use a small series for you to introduce the following methods, May be able to help you with Excel file fixes (take Excel2003 as an example).
One, the Excel file fixes to save the workbook as SYLK format
If the Excel file can be opened, converting the workbook to the SYLK format can filter out the corrupted parts of the document before saving the data.
First, open the workbook that you want. On the File menu, click the Save As command. In the Save as type list, click the SYLK (Symbolic Connection) (*.SLK) option, and then click the Save button. When you close the currently open file, open the SYLK version that you just saved.
Second, the conversion of Excel file repair to an earlier version
If you do not save an Excel workbook because of a startup failure, the last saved version may not be corrupted. Of course, this version does not include changes made to the document after the last save.
Close the open workbook, and when asked if you want to save your changes, click No. On the File menu, click Open to double-click the workbook file.
Third, Excel file repair open and repair the workbook
If the Excel file cannot be opened using the normal method at all, you can try the open and Repair feature in Excel2003 to check for and fix errors in the Excel workbook.
On the File menu, click Open. From the Look in box, locate and open the folder that contains the damaged document, and select the file you want to recover. Click the arrow next to the Open button, and then click Open and Repair.
Four, Excel file repair using Excel Viewer to open the workbook
You may wish to consider the use of Third-party software to carry out recovery work in situations where the problem cannot be solved by exhausting various methods.
The Excel Viewer is a free utility for viewing Excel workbooks, available from the Microsoft Web site, and the latest version is ExcelViewer2003.
Double-click the download file Xlviewer.exe start Setup, and then follow the instructions to complete the installation. After installation, click MicrosoftOfficeExcelViewer2003 on the Start menu to start the software and try to open the damaged workbook. You can open the damaged workbook in the program, and then copy the cells and paste them into a new workbook in Excel. If you want to delete an Excel Viewer later, you can delete it from the Add/Remove Programs in Control Panel.
Hopefully the above methods will help you with Excel file repair. If you cannot recover data from a corrupted workbook, you will need to re-create some or all of the document.