Four ways of data recovery for damaged Excel files

Abstract: The office software is very important for people working in the office like us, especially the Microsoft Excel, widely used in all kinds of different fields. It is good for you to knows something about it. Here are four methods of data recovery for damaged Excel files and tricks of how to make auto-saving for Excel files.  

Four ways of data recovery for damaged Excel files

1 Direct repair of excel files

If you have noticed or not, the latest edition of Excel owns a advantage technology, repairing directly for slightly damaged files which can not be open. Just click the additional option of “open and recovery”, the software system will check the error directly and give a pop-up dialog, the damaged Excel files can be repaired after clicking the recovery option in the dialog.

2 Transformation format

As the name suggests, it’s a method of changing the damaged Excel files to other format and save the files again in other format. If you encountered with a Excel file, and no operation could be done except opened normally， you can use the way of transformation format for repairing, in short, saving the damaged Excel file again for the format of SYLK.

3 Using Excel software itself

If the Excel file damaged for sudden power cut, you can use the feature of Excel for restoration. Reboot the computer and run the Excel, a pop-out window of “file recovery” will presented, listing all the auto-saving files while accident happened to the software, just click the file you want to recover and it will be retrieved.

4 Utilizing software of Word to open the Excel file

Try to use Word to open the Excel file. Here are the specific steps.

(1) Launch the software of Word. Choose the Excel file you want to open. Note that, if it is the first time for you to open a Excel file with Word, just install this function first.

(2) According to the file’s type, choose the workbook recovery or worksheet recovery.

(3) Delete the damaged data and change the context in the form to textual content.

(4) Change the textual content to the plain text.

(5) Launch the software of Excel, then you will open the plain text saved before.

(6) You can open the file successfully by following the tips of “the text import wizard”.

    

By using this method, you need reset all the formula and suffer from a little data loss.

How to set self-saving for the Excel files

It is a miserable thing if you encounter computer crash or sudden cut out without setting self-saving of Excel files, you will lose all the files. Remember to set self-saving for the Excel and here are the operating procedures.

(1) Launch the software of Excel, click “file” in the upper-right corner.

(2) Click “option”.

(3) Click “save”. Set time interval and saving path in the interface.

(4) Clicks “OK”, then you will complete.

Tips: If you deleted the data in the Excel accidentally, don’t panic, you can recover it by using the data recovery software. Like Hdata Recovery Software, a powerful, easy-to-use data recovery software, with it’s pro-data scanning core, could deeply scan the lost data and completely get it back, for avoiding of partly data recovery or unreadable of recovered data.