Recover overwritten Excel (.xlsx) file

A user has overwritten an Excel (.xlsx) file by deleting over 100 lines of rows, then saving the file and closing it.

There is no backup in place for the folder he has saved it into.

I tried ActiveUndelete and File Scavenger in an attempt to recover it, but it doesn't give you the option of choosing a previous date. Unfortunately, it looks like these two programs will only recover the one that is missing all the data.

Question 1 - Is there anything else I can try for recovery? Are commercial data recovery experts out there able to recover such data?

Question 2 - What kind of software could we use going forward? Not just a backup software, but something that creates shadow copies or something for this Windows XP operating system. We don't have sharepoint to save revisions of files, these files were just saved on the local C-Drive.
garryshapeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dr. KlahnPrincipal Software EngineerCommented:
The data is probably gone.  Probably, not definitely.  Without knowing the internals of Excel, this is probably what happened.

When the spreadsheet data was deleted, and the file was saved, the file containing the data was most likely updated, rather than delete the old one and create a new one.  In this case, there is nothing left on the disk but fractional magnetic flux changes under the zeroed bits.

The US government claims that, by re-reading the changed data many times, they can detect what is left of the original data as tiny deviations under the new data.  This requires specially built hardware that couples directly to the read heads.  There may be some commercial data recovery operations capable of doing this.  It would come at a very high price.

As to other things you can try ... I've found R-Studio useful, and it can recover files having the same name -- "old copies," as you say.  Here's the catch:  The longer a system runs after a file is deleted, the more likely that the clusters that contained those files are reused.

To prevent this occurring in the future -- See this web page, which details how to turn on automatic backup in Excel.  At least that will give you one level of backup.  

http://domino.lancs.ac.uk/pub/usghelpdesk.nsf/aff64e3ca4d862fd80256801006e0a22/3B01D23A1FFB72858025685F00367242?OpenDocument

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nobusCommented:
contact these guys, and see what they offer : http://www.gillware.com/      
garryshapeAuthor Commented:
I understand System Restore also doesn't backup documents.

Is there a way in Windows XP to include those files in system restore?
nobusCommented:
no - it is only for OS files...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Disaster Recovery

From novice to tech pro — start learning today.