Solved

excel corrupted and unrepairable -  Are there ANY other options here?  Lost 2 months of work

Posted on 2010-09-24
8
1,516 Views
Last Modified: 2012-05-10
I have a rather large excel workbook (3MB) on my server.  A couple users open it via a network shortcut.  This morning one user had it open as usual and the power went out for about 1 hour.... ended up using up the battery backup and killing my server.  Now 2 sheets in the file (about 2 months of work) are completely gone.

When I try to open the file it says "Excel found unreadable content in MY FILE NAME. Do you want to recover the contents of this workbook?  If you trust the source of this workbook, click Yes.

After excel attempts to repair it comes up with "Excel was able to open the file by repairing or removing the unreadable content."  Then lists the following:
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Replaced Part: /xl/worksheets/sheet8.xml part with XML error.  Quote expected. Line 2, column 103564.
Replaced Part: /xl/worksheets/sheet9.xml part with XML error.  Whitespace expected. Line 2, column 2308303.
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)

Now 2 sheets are completely blank... losing over 2 months of work.  I've tried a few different excel repair tools I found online but non have been successful.  

My question is:  Is there ANYTHING I can do to recover this?  Are there companies out there that would specialize in something like this?  It's 2 months of work so paying someone to help would be well worth it.

ANY ADVICE IS APPRECIATED!!

PS. The last server backup ran over a month ago.... so recovering the file from backup isn't much of an option.
0
Comment
Question by:MFredin
8 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 167 total points
ID: 33756009
If you tryed some tools and they where not much of a help, that makes me think that there is nothing that you can do to recover the lost information I'm afraid. Companies like this one:

http://www.stellarinfo.com/

normally recover deleted files or damaged disks not information inside files for what I know.

jppinto
0
 
LVL 2

Assisted Solution

by:jimponder
jimponder earned 167 total points
ID: 33756958
Is the auto backup feature turned on?  What about the temp files that are stored on the user's temp directory whenever they open one of these types of files?  Do you have Windows Shadow Service turned on?  Undelete?  
0
 

Author Comment

by:MFredin
ID: 33757353
I don't have any of these features turned on.... I checked in windows/temp directory but nothing.  
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 8

Assisted Solution

by:twohawks
twohawks earned 166 total points
ID: 33762707
I am running out the door, so briefly, what I would od...

1) Of course, make sure you have cloned/imaged  the drive first

2) Find utilities for recovering deleted files.  There should be a handful of them that can recover recent previous saves of the file in question.*

*Keep in mind, the more the drive is used right now the less likely it will be that you can recover a previously saved version.

3) If you have copy of the large file at time of crash, a recovery expert may be able to retrieve the tables from it.  The results will be really messy, but there's probably data in there. (Is this a complex spreadsheet with macros and charts, or simple straight rows and columns of records and such?)

I am sorry I do not have time to search my drive and recommend some tools... my development machine is in disaster recovery on the bench right now ;^)

I have successfully recovered seemingly totally fubared excel spreads.  I wouldn't give up too easily ;^)

Luck.
0
 
LVL 8

Expert Comment

by:twohawks
ID: 33762740
Oh yeah...best to hook it up as a slave while performing recovery tasks.
0
 

Author Comment

by:MFredin
ID: 33969580
Can we split the points between the contributers?
0
 
LVL 8

Expert Comment

by:twohawks
ID: 33970996
Thanks, MFredin.  I hope things worked out for you.  If they did, it would be helpful to future searchers to know what that was.
Cheers, TwoHawks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question