How Excel file corruption fixes

Source: Internet
Author: User

Method one, manual repair of damaged work thin

For workbooks that are damaged by a program failure, the user can manually restore the computers, mainly in the Open dialog box, the action is:

Step one, start the Excel2010 program, on the File tab, click the Open button, open the Open dialog box, select the workbook you want to repair, click the Drop-down button to the right of the Open button, and select Open and Repair in the pop-up Drop-down menu, as shown in the figure:

Step two, in the Open Prompt dialog box, click the Repair button, as shown in the figure:

The fix to Workbook name].xlsx dialog box opens, and clicking the Close button opens and repairs the selected workbook. If you click the hyperlink in the Click View Repair Record Bar, you can view detailed repair information, as shown in the figure:

Method Two, automatic repair due to program failure of the work of the Thin

Excel has the ability to automatically fix a workbook that is damaged by a program failure, and when you open a damaged workbook, EXCCL automatically starts the file recovery mode, reopening, and doing the repair work.

The Document Recovery pane appears to the left of the Open workbook action interface. It lists all workbooks that were closed due to a program failure, the mouse cursor moved to the corresponding workbook, click the button on the right, and select the show Repair command in the pop-up drop-down menu to display the contents of the auto fix, select Open Command opens the workbook, as shown in the figure:

Skill: Repair Data corruption work thin

If the workbook's data is corrupted, a message pops up when you open the workbook. Prompts the workbook to discover what is unreadable, clicking the Yes button in the prompt dialog box opens the repair to the Workbook Name]xlsx dialog box, which shows that the workbook has been repaired and deleted unreadable data, click Close button to open the repaired file.

Also, if the program fails, the document Recovery pane is not displayed when you open the workbook again. You may have disabled document recovery for the workbook while you were working on the workbook, and if you want to enable document recovery, open the Excel Options dialog box by clicking the Options button on the File tab. In the Save tab, uncheck the "Disable automatic recovery of this workbook only" check box.

Method III, using "Excel Recovery" to repair corrupted files

The Excel Recovery software is designed to repair damaged Excel files. After downloading and installing the "Excel Recovery" software, you can start the software for repair operations, as follows:

Step one, start Excelrecovery, click the Repair button in the window, as shown in the picture:

Step two, select the Excel file you want to repair, click the "Recover" button to begin the automatic repair work, as shown in Figure 2-38, set the saved name in the Open dialog box when you are done, click the Save button to save the repaired file, and complete the repair work as shown in the figure:

Method Four, Save as SYLK format repair shun-bad work thin

Save the workbook as a SYLK format, and you can filter the corrupted elements out of the meter to fix the damaged Excel file with the following specific methods:

On the File tab, click the Save As button. Open the Save As dialog box, select the SYLK (symbolic Link) option in the Save as Type Drop-down list box, and then click the Save button when you are finished, as shown in the figure:

Method Five, use Word to repair a damaged workbook

You can also repair a damaged workbook by using Word to convert the format of an Excel file in XLS format:

Step one, start the Word program, click the Open button on the File menu, open the Open dialog box, and select the All Files option in the File Type Drop-down list box, as shown in the figure:

Computer Tutorials

Step two, locate and select the destination workbook, click the Drop-down button to the right of the Open button, and select Open and Repair in the pop-up Drop-down menu, as shown in the figure:

Step three, open the prompt dialog box, prompting the file to be opened by a text converter. Click the Yes button to determine that the file opens with the Open Worksheet dialog box open, select Open a specific worksheet in the document in open workbook Drop-down list box, or open the entire workbook, click OK to open the file , which can be converted to a text file and imported into Excel.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.