excel 2010 file corrupted: software for recovery?

[xSauronx]

have an inventory sheet for a clinic id rather not have to re-create, anyone know of/used any software/vendor to restore excel data quick and easy? free is obviously preferable but if its cheap i cant complain, 3 hours of work in it so if its expensive ill just redo the inventory.

/havent had time to google yet, maybe tonight

[TSDible]

Have you tried to open it in openoffice or something similar?

What about backups? Any older versions floating around that you would not have to put everything back in to?

[blurredvision]

If you haven't tried opening it on another computer with Office, or OpenOffice as suggested above, I'd start with that. I've seen files that appear to be corrupted but it's actually the Office install that needed to be repaired.

[GrumpyMan]

What I have done before, and it always doesn't work but worth a shot, is copy the file into another folder so you can save the original. Then change the extension to .txt. Use Excel to open it. It will tell you that the file does not seem to be good or correct or in the format specified, and ask you do you still want to open it? Say yes and see if that doen't work for you to resave it into an uncorrupted .xls or xlsx again.

[xSauronx]

the first thing i tried was libreoffice, still nada
grumpyman: just tried your idea, it sees the template information but none of the data

originally i created an excel file as a template for inventory: cpu, pc name, ip, serial number, location, etc.

i was working with the file in quickoffice on my nook color, which ive done several times before without issue. i saved it every 5 minutes or so, and when i got home i shared the file to dropbox so i could clean it up on my pc

except when i opened it from dropbox it was corrupt
then when i plugged in the nook to my pc with a usb cable...that copy was corrupt, too.

googled around and MS had some suggestions, like saving each worksheet as a sylk file, or saving all of it as an html file and trying to read it that way...nada.


kind of a pain in the ass, but not the end of the world. not really sure what happened that corrupted it, but ill just have to redo the inventory tomorrow or monday.

[Edgy]

If I had the same issue, I would next try importing data from the corrupted file instead of trying to open it (open blank excel and import data from corrupted excel file).

I have had few instances where all data were imported successfully from an excel file that could not be opened by itself.