How to fix Excel garbled

Excel garbled how to repair Excel electronic reporting software is one of the most widely used software, its data processing, chart function and a variety of functions and tools are loved by the majority of users. The Excel file is a workbook, and a workbook can contain 255 worksheets, each of which can contain a large amount of data. What if an Excel file is a bit corrupted and does not open properly?

"Excel garbled how to fix"

　Method One: Manual processing

1 open Word, click Open on the File menu

Excel 2003 official version download address: http://www.duote.com/soft/7688.html

Excel 2007 official version download address: http://www.duote.com/soft/36009.html

2 Select all files in the file type, locate and select the. xls file you want to repair, click the Open button

3 opens, if Excel has only one worksheet, it automatically loads word as a table, and if the file is made up of multiple worksheets, you can open only one worksheet at a time.

4 Delete some corrupted data in the file.

5 Use the mouse to select the table, in the "Table" menu, select "Table to Text", you can choose the "," separator or other separators.

6 Save as a text file. txt.

7 Open the text file directly in Excel and save it as an Excel file with a different name.

8 Note: This method of repair is to use Word directly read the function of Excel file, the method is not damaged in the file header, but the file content is more effective, if the file header has been corrupted when the Excel file, this method may not be successful, you must rely on other methods.

　　Method Two: Repair tools with Excel

Concept Data Company provides a repair tool specifically for repairing Excel corrupted files excelrecovery, which downloads the Web site www.excelrecovery.com.

After downloading the software installation, you can automatically install the Excel hotfix in an Excel application, and under the File menu, add a recovery option that you can use to fix a corrupted file. The use method is:

Open Excel.

The dialog box for Excel Recovery opens when you click the Recover option on the File menu.

Specify the Excel file you want to repair, and then press the [Recover] button.

Automatic repair, need to wait a while.

The repaired file will be opened.

Save as a new file name to complete the repair of the file.

Note: This version can only fix normal files, cannot fix Excel files with Visual Basic code, charts, and include passwords, and if you need to fix them, register. It should be noted that the files saved in the floppy disk is very easy to damage, can be repaired after the damage, but if you save the file Disk 0 track damaged or not correctly read and write failures, you must first repair the disk and files, and then repair the Excel file with the above method.