How to fix Excel file corruption? Excel document garbled repair strategy in Win7 environment

Excel documents give us too much convenience in our work. Even when many users are working on forms, they are used to documenting Excel. It can be said that Excel is one of the essential software for office! Many users U disk always prepare Excel documents for emergency, but sometimes the time is too tight, some users open the Excel document without closing the U disk directly, which leads to the next use of the Excel document. There is a situation of damage. Read below to understand the Excel document corruption repair strategy in Win7 environment.


corrupted Excel document

borrow WPS software to open Excel documents is still not enough

Excel document garbled

An automatic repair:

Excel garble repair tool download

ExcelFIX (Excel damage repair) Download

Auto repair method:

This method is suitable for Excel XP program running failure shutdown program Or the file caused by power failure is damaged. Re-run Excel XP, it will automatically pop up the "Document Recovery" window, and list all files that have been automatically restored in this window. Use the mouse to select the file you want to keep and click the arrow next to the specified file name and select “Open” as needed. “Save as & rdquo;. “Show fixes”.

By default, Excel XP does not enable automatic repair, so preset: first click the <quo;tool →options" command in the menu bar, click &ldquo in the settings box. ;Save & rdquo; tab, disable the "Automatically disable" checkbox, then check "Save automatic recovery information every X minutes" and enter the specified interval frequency, and finally click & ldquo; OK & rdquo ; Complete the setup.

If you have not automatically popped up the "Document Recovery" window, you can try to open the automatically recovered file manually: execute the “file →open” command, use “search scope” The box locates and opens the folder where Excel XP saves the auto-recovery file. If you don't know the location of the folder, you can view the path in the “Automatically restore file save location” box, and then in the “File Type” dialog box. In the middle, select the "All files (*.*)" option, and select the file to be restored, and finally click the "Open" button to open the file for automatic repair.

Second, manual repair:

1, conversion format method

is to save the damaged Excel XP workbook save format as .SYLK If you can open the damaged file, Just can't do various editing and printing operations, so it is recommended to try this method first.

2, direct repair method

The latest version of Excel XP in the "Open" window "Open" & rdquo; button directly repair damaged files & ldquo; open and repair & rdquo ; function, this method is suitable for the case where the conventional method cannot open the damaged file.

3, stealing the column method

When you can't open the damaged Excel XP file, you can also try to open it with Word. The operation is as follows:

(1) Run the Word program and select the Excel file to be opened;

(2) If you use the Word program to open the Excel XP file for the first time, there may be “Microsoft Word cannot Import the specified format. This feature is not currently installed. Is it installed now? ” prompt information, you can insert the Microsoft office installation disk to install;

(3) according to the prompts of the Word program to choose to repair the entire workbook or a worksheet;

(4 First delete the corrupted data in the file, then move the mouse to the table, and in the menu bar, execute “table →convert →table to text” command, select tab as text separator , convert the contents of the form to text content, and save as a plain text file;

(5) Run the Excel XP program, open the text file just saved;

(6) Then according to &ldquo The text import wizard & rdquo; prompts to open the file.

The repaired worksheet is basically the same as the original worksheet. The difference is that all the formulas in the table need to be reset, and some texts. The number format is missing.

The above is about the repair strategy of Excel document corruption in Win7 environment, Excel document can be automatically repaired, and this process will be executed when Excel software opens Excel document, so some users open Excel documents. The time will be a little longer.