How to recover corrupted Excel workbook

There are 3 ways to recover a corrupted Excel file.

Option 1. Recover or repair the file manually with Excel

The steps for manually recovering a workbook are quite simple.

1. Select Open from the File menu. In Excel 2007, click the Office button and select Open.

2. Using the Look In control, locate and specify the corrupted workbook. 3. From the Open button?s dropdown list, choose ?Open and Repair?.

4. If this is your first attempt to manually recover the workbook, click Repair in the dialogue box that appears.

Usually Excel will be able to recover the entire file, but it doesn?t always work. If you?ve tried this process and you can?t recover the entire file, you can still at least recover your data. To do so, click Extract Data in step 4.

Option 2. Use the last saved version

If the file becomes corrupted while you?re working in the workbook, DON?T save the file. Instead, revert to the last saved version of the file. Doing so without saving first should get rid of whatever was corrupting the file. Be forewarned ? you could possibly lose some data, but if you?ve been regularly saving your work (as you should be!) this is a lot better than losing the entire file.

To revert to the last saved version:

1. Choose Open from the File menu. In Excel 2007, click the Office button and select Open.

2. Using the Look In control, locate and specify the corrupted workbook.

3. Click Open.

Option 3. Try opening the file in another program

If Excel can?t open the corrupted workbook, there are several other programs you can use to try to open it. Microsoft Tools is one option:

1. From the Windows XP Start menu, choose All Programs. 2. Select Microsoft Office, then Microsoft Office Tools and Microsoft Office Application Recovery. 3. In the dialogue box that appears, choose Microsoft Office Excel. 4. Click Recover Application.

You can also try opening the workbook in Microsoft WordPad. The only caveat: WordPad will convert all the data into text, and it won?t recover formulas. However, it will at least restore your important data. It will also recover your VBA procedures (macros) ? just search recovered text for ?Sub? and ?Function? to find them.

You may also be able to open the corrupted .xls file in Word, but again, the data is the only thing you?ll be able to recover - and even that may give you mixed results. So only try this as a last resort!

Can You Recover Deleted Files From the Recycle Bin?

I get many people contacting me in a desperate situation asking if they can recover deleted files from the recycle bin. Firstly, if you have simply deleted your files and they have gone to the recycle bin then you can easily recover the files with the press of a button. However it is a different story if you have gone to the recycle bin, and then deleted all the files in there. Therefore if you simply want to recover files from your recycle bin then this is very easy. This article is about using software to recover deleted files that have also been deleted from the recycle bin.

The Recycle Bin offers a kind of protection for the data on our computers. When we delete some files, they will be stored in the Recycle Bin, and when you need them back, you just need to turn to Recycle Bin to restore them. Of course, this is only available when you delete your files by hitting Delete key or dray them into the Recycle Bin. If you deleted files with Shift + Delete or you emptied the Recycle Bin, you can’t directly recover deleted files from the Recycle Bin. However, it’s not impossible to recover deleted files from the Recycle Bin, even though the Windows displayed you a warning that the file would be deleted permanently.

Actually when a file is deleted from your Recycle Bin, its content still remains and isn’t destroyed immediately. The Windows simply marks the hard drive space as being available for re-use. So there is a way to retrieve files deleted from the Recycle Bin, only when you adopt a right Recycle Bin recovery. Spotmau PowerSuite Golden is such a program, which can recover your Recycle Bin.

Please note: You should never install any software at all on the drive that you want to recover the files from. The only reason you can recover files that have been deleted is because they have not been overwritten yet.

I have mentioned a free program to recover your files, however if it does not work you run the risk of losing your data. If your files are not that important to you I suggest you go and give it a go as it is good software. However if your files are irreplaceable then I am suggesting you take a look at this software, because they guarantee that you will recover your files. Also by buying the software, you are entitled to free instant chat support.

Install and launch this Recycle Bin recovery on your computer. To recover deleted files from Recycle Bin, you should select the “Deleted Recovery” from “Data Recovery Kit”, which can help you find back all files you deleted before.

To recover the accurate deleted files that you want, you can select the partition at the beginning. From the Properties of the Recycle Bin on your desktop, you can get the information that each local disk has its own recycle bin here. So if you still remember the place that the file located before you deleted them, you just need to select to scan that partition.
To save more time, you also can set the content that you are going to scan, such as the file type, the time you deleted the files, and even the file name, which will save you lots of time and recover your files more accurately.

After the scanning is finished, click to save files that the PowerSuite Golden has found. If there are not only the files you want in the scanning result, you can check the one you want for recovery only. Or you can recover all of them, and then pick out your desired one among them.

OK. Your deleted files from the Recycle Bin have been back now! What’s more, if the file is deleted directly with Shift + Delete, skipping the Recycle Bin, you also can retrieve them with this way.

The World Leader in Data Recovery Software! No Recovery, No Charge!

If you decide to recover deleted files from the recycle bin as soon as you realize they are gone, then you have a good chance of recovery. However if you have been using the computer and saving files and installing programs, your chances are close to 0. if this is the case I suggest you go to the PowerSuite Golden website and talk to an online consultant.

Tagged as: a recycle bin, accidentally deleted files, deleted files, recover deleted files