Excel file is a workbook, a workbook can contain 255 worksheets, and each worksheet can contain large amounts of data. If an Excel file is a little damaged, it cannot open properly, then how to do it? Method One: Using Excel repair.
Excel file is a workbook, a workbook can contain 255 worksheets, and each worksheet can contain large amounts of data. If an Excel file is a little damaged, it cannot open properly, then how to do it?
Method One: Using Excel repair tool
Concept Data Company offers a specialized repair tool Excel Recovery used to repair damaged Excel files; the software download site is http://www.excelrecovery.com
After downloading the software installed, you can automatically fix is installed in Excel Excel application, under the File menu, and more of a Recovery option, if the damaged file, you can use this option to repair. Use is:
Open Excel. Click the "File" menu "Recover" option, Excel Recovery dialog box will open. Specify the Excel file you want to repair, and then press the [Recover] button. Auto repair, need to wait a while. The repaired file will be opened. Save as a new file name, to complete the repair work file.
Note: This version only fixes common file cannot be repaired with Visual Basic code, charts and Excel file that contains the password, if you need to repair these files, please register. It should be noted that the file is saved in the floppy disk are easily damaged, after the above methods can be used to repair damage, but if the disk zero track to save the file is damaged or not properly read other faults, you must first repair the disk and file, and then the above method to repair Excel files.
Method two: manual handling
into the Word, in the "File / Open / File Types", select "All Files", designated to repair .xls file, open, if only one Excel worksheet, in tabular form is automatically loaded into Word, If the file is composed by multiple worksheets, you can only open a worksheet.
The damaged portion of the file data deleted.
Use the mouse to select a table in the "Table" menu select "Table-to-text", the choice "," delimiter or other delimiters.
Another saved as a text file .txt. In Excel, open the text file directly, save it as an Excel file to another name.
Note: This repair method is more effective at functional use of Word to read Excel files directly implement the method in the file header is not damaged, but the file contents are damaged, Excel file if the file header has been damaged, and this The method may not be successful, must resort to other methods.
File repair methods more, if a Word document, there are tools Word Recovery specifically for repair Word files.
Method One: Using Excel repair tool
Concept Data Company offers a specialized repair tool Excel Recovery used to repair damaged Excel files; the software download site is http://www.excelrecovery.com
After downloading the software installed, you can automatically fix is installed in Excel Excel application, under the File menu, and more of a Recovery option, if the damaged file, you can use this option to repair. Use is:
Open Excel. Click the "File" menu "Recover" option, Excel Recovery dialog box will open. Specify the Excel file you want to repair, and then press the [Recover] button. Auto repair, need to wait a while. The repaired file will be opened. Save as a new file name, to complete the repair work file.
Note: This version only fixes common file cannot be repaired with Visual Basic code, charts and Excel file that contains the password, if you need to repair these files, please register. It should be noted that the file is saved in the floppy disk are easily damaged, after the above methods can be used to repair damage, but if the disk zero track to save the file is damaged or not properly read other faults, you must first repair the disk and file, and then the above method to repair Excel files.
Method two: manual handling
into the Word, in the "File / Open / File Types", select "All Files", designated to repair .xls file, open, if only one Excel worksheet, in tabular form is automatically loaded into Word, If the file is composed by multiple worksheets, you can only open a worksheet.
The damaged portion of the file data deleted.
Use the mouse to select a table in the "Table" menu select "Table-to-text", the choice "," delimiter or other delimiters.
Another saved as a text file .txt. In Excel, open the text file directly, save it as an Excel file to another name.
Note: This repair method is more effective at functional use of Word to read Excel files directly implement the method in the file header is not damaged, but the file contents are damaged, Excel file if the file header has been damaged, and this The method may not be successful, must resort to other methods.
File repair methods more, if a Word document, there are tools Word Recovery specifically for repair Word files.