Home >Software Tutorial >Office Software >Recover damaged excel files
1. Conversion format method
Select the damaged Excel XP workbook as SYLK as the save format. If you can open the damaged file but cannot perform various editing and printing operations, then it is recommended to try this method first.
2. Direct repair method
The latest version of Excel
3. Substituting the beam with the pillar method
When you encounter a damaged Excel XP file that cannot be opened, you can also try to use Word to open it. The operation is as follows:
(1) Run the Word program and select the Excel file you want to open;
(2) If you use the Word program to open an Excel Installation disk to install;
(3) Follow the prompts of the Word program to choose to repair the entire workbook or a certain worksheet;
(4) First delete the damaged data in the file, then move the mouse to the table, and execute the "Table → Convert → Convert Table to Text" command in the menu bar, and select the tab character to separate the text. character, convert the table content into text content, and then save it as a plain text format file;
(5) Run the Excel XP program and open the text file just saved;
(6) Then follow the prompts of the "Text Import Wizard" to open the file smoothly.
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 text and number formats are lost.
4. Automatic repair method
This method is suitable for file damage caused by the Excel XP program running failure, shutting down the program or power outage. Rerun Excel XP, it will automatically pop up the "Document Recovery" window and list all the files that have been automatically recovered in the 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", "Save As", "Show Repair" as needed.
By default, Excel Deselect the "Disable automatic recovery" checkbox, then select the "Save automatic recovery information every X minutes" checkbox, enter the specified interval frequency, and finally click "OK" to complete the settings.
If the "Document Recovery" window does not pop up automatically, you can try to open the automatically recovered file manually: execute the "File → Open" command in sequence, use the "Search Range" box to locate and open Excel XP to save the automatically recovered file folder. If you don't know the location of that folder, you can check the path in the "Auto-recovery file save location" box, and then in the "File type" selection dialog box, select the "All files (*.*)" option. And select the files you want to recover, and finally click the "Open" button to open the files for automatic repair.
5. Tool repair method
If none of the above methods can repair the file, you can also use "ExcelRecovery" which is specially designed to repair damaged Excel XP files. The software will automatically add the repair program to the Excel software, which is represented by adding a "Recovery" command under the "File" menu, which can automatically open the damaged file in repair mode.
Trick 1: Save the workbook as SYLK format
If the Excel file can be opened, converting the workbook to SYLK format can filter out the damaged parts of the document before saving the data.
First, open the required workbook. In the "File" menu, click the "Save As" command. In the "Save as type" list, click the "SYLK (Symbolic Link) (*.slk)" option (Figure 1), and then click the "Save" button. After closing the currently opened file, open the SYLK version you just saved.
Trick 2: Convert to an earlier version
If the Excel workbook is not saved due to a startup failure, the last saved version may not be corrupted. Of course, this version does not include changes made to the document since the last save.
Close the open workbook and click "No" when asked whether to save changes. In the "File" menu, click the "Open" command and double-click the workbook file.
Trick 3: Open and repair the workbook
If the Excel file cannot be opened using conventional methods at all, you can try the "Open and Repair" function in Excel 2003, which can check and repair errors in the Excel workbook.
In the "File" menu, click the "Open" command. Through the "Look in" box, locate and open the folder containing the damaged documents and select the files you want to recover. Click the arrow next to the Open button, then click Open and Repair
Trick 4: Open the workbook with Excel viewer
If the problem cannot be solved after exhausting various methods, you may wish to consider using third-party software to perform recovery work.
Excel Viewer is a free utility for viewing Excel workbooks. It can be obtained from the Microsoft website. The latest version is Excel Viewer 2003.
Double-click the downloaded file xlviewer.exe to start the installation program, and then follow the instructions to complete the installation. After the installation is complete, click "Microsoft Office Excel Viewer 2003" in the "Start" menu to start the software (Figure 3) and try to open the damaged workbook. You can open the damaged workbook in the program, then copy the cells and paste them into a new workbook in Excel. If you want to delete the Excel viewer program in the future, you can delete it through "Add/Remove Programs" in the "Control Panel".
Trick 1: Save the workbook as SYLK format
If the Excel file can be opened, converting the workbook to SYLK format can filter out the damaged parts of the document before saving the data.
First, open the required workbook. In the "File" menu, click the "Save As" command. In the "Save as type" list, click the "SYLK (Symbolic Link) (*.slk)" option, and then click the "Save" button. After closing the currently opened file, open the SYLK version you just saved.
Trick 2: Convert to an earlier version
If the Excel workbook is not saved due to a startup failure, the last saved version may not be corrupted. Of course, this version does not include changes made to the document since the last save.
Close the open workbook and click "No" when asked whether to save changes. In the "File" menu, click the "Open" command and double-click the workbook file.
Trick 3: Open and repair the workbook
If the Excel file cannot be opened using conventional methods at all, you can try the "Open and Repair" function in Excel 2003, which can check and repair errors in the Excel workbook.
In the "File" menu, click the "Open" command. Through the "Look in" box, locate and open the folder containing the damaged documents and select the files you want to recover. Just click the arrow next to the Open button and then click Open and Repair.
Trick 4: Open the workbook with Excel viewer
If the problem cannot be solved after exhausting various methods, you may wish to consider using third-party software to perform recovery work.
Excel Viewer is a free utility for viewing Excel workbooks. It can be obtained from the Microsoft website. The latest version is Excel Viewer 2003.
Double-click the downloaded file xlviewer.exe to start the installation program, and then follow the instructions to complete the installation. After the installation is complete, click "Microsoft Office Excel Viewer 2003" in the "Start" menu to start the software and try to open the damaged workbook. You can open the damaged workbook in the program, then copy the cells and paste them into a new workbook in Excel. If you want to delete the Excel viewer program in the future, you can delete it through "Add/Remove Programs" in the "Control Panel".
Hope the above methods can help you recover damaged Excel files. If you cannot recover the data in a damaged workbook, you may need to recreate part or all of the document.
The above is the detailed content of Recover damaged excel files. For more information, please follow other related articles on the PHP Chinese website!