Retrieving missing Excel data

5 pts.
Tags:
Backup & recovery
excel
Excel Database
Excel error messages
Excel worksheets
I had an excel file with 10 worksheets on it. I opened the file yesterday and found the whole 10 worksheets missing from the file. What could have caused it and is there a way to retrieve this data back to the file?
ASKED: August 25, 2010  11:17 PM
UPDATED: April 3, 2014  8:02 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Where is the file stored? On a shared network drive? If so you may be able to use shadow copy (Previous versions) to recover your file. Right click on the folder it lives in and see if you have a previous versions tab. Then you can select the day you want to go back to and copy the file out.

If not is the folder backedup by a nightly or weekly backup job? If so have your network administrator restore it from backup.

Finally if all else fails look for files in the same directory ads your file that start with ~ these are temporary files and one of them may contain your data.

Good luck and make sure you always have a solid backup.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Brady37
    Recover excel files thanks to next utility http://www.excel.fixtoolbox.com utility starts recovering excel files with MS Excel 95 version
    10 pointsBadges:
    report
  • Jackcatel
    Try some option

    1. Before open excel file --> click Right button on the file --> Select properties options -- Select Previous versions on the right of the tabs.
    2. Retrieve my lost file "C:\Users\User name\AppData\Roaming\Microsoft\Excel\Book1302741752573156243\File name((***.*)).xlsb


    Hope this can help you.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following