Link to home
Start Free TrialLog in
Avatar of pawankk
pawankk

asked on

Reparing Corrupted Excel files?

I have created an File in Excel 2000 now it is not opening (Unable to read)i have no backup of it does there is any free utility which can be downloaded.Please dont tell me any demo as they only do part of it.
Avatar of tskelly082598
tskelly082598

You might try QuickView.
I found these instructions by searching the internet, but I don't have a corrupt file to test if it works:

"Try using a blank worksheet, and create an external reference to the corrupt one. The formula would read  ='[Filename.xls]SheetName'!$A$1. If the correct entry shows up, you can then change the absolute reference to a relative by deleting the $ signs.
 
Then use the fill handle to fill across, then down, until you recover all the data. Do this for each sheet tab in the corrupted document," if you know their names.
 
ASKER CERTIFIED SOLUTION
Avatar of tituba2
tituba2

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anne Troy
Try opening the file from Word. (Change the files of type in word to all files or *.xls files.) This will not bring functions over, nor, I believe, will it bring over more than one sheet. However, if it opens from Word, it'll be in a table. Click inside the table, hit Table-Select table, copy, open a new Excel worksheet and paste.

At very least, try Words files of type "recover text from any file" and open it that way. You may then be able to do find(s) and replace(s) to put commas or tabs between values, save as text, then open from Excel and use the import text wizard to get your data back. I'm always game to try recovering a file. You can email it to dreamboat@v35.com...
Here are two urls, the second one has a good recovery tool also.

http://support.microsoft.com/support/kb/articles/Q172/3/58.ASP


http://officerecovery.com/excel/

Dave


I didn't know that have never tried the one you identified. :>) Dave
It is an excellent product.  I downloaded the free demo when
I was desperate to open a corrupt Excel workbook.
This workbook would not open with any of the
Microsoft fixes that are listed in their knowledge base.

It worked so well that my company purchased the
Word & Excel complete recovery product.  Wouldn't you know that
I've owned the product now for three months and not
one user has had a corrupt document for me to recover!
No I meant that I have used the other site didn't know they were the same. I have used the Demo also and it did work great! But what you say does give some good feedback, I was thinking of getting the full product. :>)
hi i am having the same problem as pawankk

i downloaded and tryed excelrecovery tool  but i cannot save the files

am i doing something wrong or is it ust that the dedemo version has the save feature disabled?

as you can imagine i am quite desperate about this.


thank you, experts

ignacio
Don't know - perhaps.  If you can recover the file, I'd open an empty workbook and copy the contents over then save that one.