3 Ways to Recover a Corrupted
Excel Workbook It's your worst Excel nightmare: a damaged or corrupted workbook. This can happen for a variety of reasons -- and the good news is that there is a variety of ways to retrieve your damaged file. If a file is corrupted, Excel should normally perform an automated recovery. However, if that doesn't work, there are a few other options you can try. 1. Recover or repair the
file manually with Excel 1. Select "Open" from the File
menu. In Excel 2007, click the Office button and select "Open".
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. 2. Use the last saved
version To revert to the last saved
version: 3. Try opening the file in
another program 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!
|