excel 2010 file corrupted: software for recovery?

Status
Not open for further replies.

xSauronx

Lifer
Jul 14, 2000
19,582
4
81
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

Golden Member
Nov 4, 1999
1,697
0
76
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?
 
Oct 19, 2000
17,860
4
81
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

Diamond Member
May 14, 2001
5,780
265
136
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

Lifer
Jul 14, 2000
19,582
4
81
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

Senior member
Sep 21, 2000
366
20
81
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.
 

Joshep

Junior Member
May 15, 2014
2
0
0
Hello Everybody, I'm having the same problem right now!!! I was thinking to buy a software called ExcelFIX. Has anyone tried this?
 
Last edited:

Joshep

Junior Member
May 15, 2014
2
0
0
Thanks for the answer, I have not much time, is Recuva the best options? I don't care paying for a recovery tool, I want recover my spreadsheet.
 

BonzaiDuck

Lifer
Jun 30, 2004
16,234
1,816
126
Hmmm . . . Interesting. After several years using the CCleaner freeware, I bought the Pro version and got "Speccy" and "Recuva" as extras.

If it works that well as someone said, that will come in handy, I'm sure.
 

EvinOrva

Junior Member
Nov 29, 2014
1
0
0
Different solutions you may find out here:- http://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/481-​excel-files-corrupted – a lot of different opinions might be your saving.

How to Repair a Corrupted Excel Spreadsheet

1. Launch Excel.

2. Click the "File" drop-down menu from the top menu and select "Open."

3. Navigate to the Excel file you wish to repair. Click the arrow next to the "Open" button and select "Open and Repair."

4. Click "Repair" when prompted to recover the most recent changes to your spreadsheet.

5. Click the "File" drop-down menu from the top menu and select "Save" to save your recovered spreadsheet.
 

Fardringle

Diamond Member
Oct 23, 2000
9,200
765
126
This is the Energizer thread. It keeps going, and going, and going....

Necroed from 2012 to 2014, and again from 2014 to 2015. Silly people... ;)
 
Status
Not open for further replies.