Solved

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

Posted on 2010-09-24
8
1,632 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

724 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