Win7 system Excel file garbled repair method

  

win7 computer excel document garbled how to fix it? There are many ways to do this, we can fix it manually, or you can use the software to fix it, let's take a look at the specific operation.

Excel document corruption under Win7 environmental restoration strategy is as follows:

corrupted Excel document

borrow WPS software to open Excel documents is still not

Excel document garbled

First, automatic repair:

Excel garble repair tool download

ExcelFIX (Excel damage repair) Download

Automatic repair method:

This method is applicable to the Excel XP program running a faulty shutdown program or file corruption caused by power failure. 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 function is not currently installed, is it now installed? & rdquo; prompt information, you can insert the Microsoft office installation disk to install;

(3) follow the prompts of the Word program to choose to repair the entire workbook or some Worksheet;

(4) First delete the corrupted data in the file, then move the mouse to the table, and then execute “table →convert →table to text in the menu bar&rdquo ; command, select tabs as text separators, convert the contents of the table to text content, and save as a plain text file;

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

(6) Then you can open the file smoothly according to the <;Text Import Wizard” prompt.

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 lost. Want to know more exciting tutorials, please continue to pay attention to this website!

Copyright © Windows knowledge All Rights Reserved