Excel File is Damaged and not opening??????

Question

My Microsoft Excel Worksheet is Damagaed and Not opening then what can I Do?????

Answer 1

Try this...

1. Open a blank Excel sheet (might be a NEw one.)
2. Go to the menu "File-->Open".
3. In the dialog for Opening the files, browse to the folder, select the damaged file.
4. Now observe the Open button. U shall see a dropdown (down arrow).
5. Click on the arrow.
6. Click on "Open and Repair".

Might work ....
All the best...

Answer 2

There is one thing you can do to recover as much of the data as possible.

Open a blank workbook, then create a link formula to the damaged file. If the damaged file is called File.xls for example then in cell A1 of Sheet1 type in:

=['C:\Files\[File.xls]Sheet1, !A1

Copy this formula down and to the right in your worksheet. It will try to recover the data from Sheet1 in your damaged file. It will recover the data that can be recovered, but not the formulas.

This works because a link formula does not need the source file to be open to recover the data.

Good luck in your endeavors! Next time back it up.

Answer 3

I have had success opening damaged XL documents in Open Office, saving them in a different name as XL .xls type and then been able to use them with XL again.