Recover Unsaved Excel Document

A staff member was working for 4 hours on an Excel document and then everything sht down and the document was lost. Is there any program or place to look to find this document? We use Office 2000 NOT XP so there is not auto save.

Please help!

Who is Participating?

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

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.

I doubt if she can get it back ... which is my first thought.. I need to research on this

HOW TO: Use the Microsoft Office Application Recovery Tool in Office Programs;en-us;294933

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Hi gsfmedia,

very annoying! I'm afraid I've never found anything lost that way, and I've looked really hard.

You really should use the AutoSave feature, - it's an add-on but comes with Excel as standard.

Kind regards,
Anne TroyEast Coast ManagerCommented:
You can do a search on the hard drive for *.tmp and ~*.* files.

Check the sizes to find one similar in size to the original.
Check the modified time and date, looking for something around the time the machine died.

Sven is right--they're rarely found, especially on the new OS's, but I have had people find something from time to time.

Turn her autorecover addin on, or teach her Ctrl+S.
If it's really important then you can buy a third party recovery tool. You could try with "Lost & Found" from first. The important thing is not to use the computer until you've seen if you can find the file, since you don't want to overwrite the data.

Anne TroyEast Coast ManagerCommented:
Sorry, GSF. I didn't say that if you DO find files in that group that might be candidates, change the name to have an xls extension and try opening it.

Also, when you're done, those files can be deleted.

the problem is: it'll probably take you much longer to just go through all the options for trying to recover the file, than it will take your user to redo the job.

Furthermore, some of the tools for recovering data on a low level are straight out dangerous if you are not truly well skilled in computer management (not including tools like the one Steve suggest, but things like Disk Editors, etc.).

You could consider it as learning a new task of course, - but how often would you need it? I recommend learning to prevent the problem instead: it's easier and more valuable to your users.

If you are uncertain about enabling the autorecover/autosave function in MS Office, please let us know.

Kind regards,
Karen FalandaysTraining SpecialistCommented:
Just one comment: Enabling autosave will NOT help recover a file that was not saved UNLESS it was lost during a crash or power outage. Even then it is not a guarantee. The autosave in Excel is not turned on for a reason, as it acts very differently from the autosave feature in Word. I encourage you all to research this first!
Anne TroyEast Coast ManagerCommented:
You're right too, Karen. I was never much of a proponent of the feature in either program. It's deceptive. Here's why:

If your application locks up while working on a file that you do not want to lose, try closing all of your other programs FIRST, then hit your power button. This emulates the power outage that Karen talks about. If you End task instead...YOU WILL NOT GET YOUR FILE.
Auto save woks OK in Word and I've got documents back from it. In Excel the problem is it nags you.

I've lost data in Excel because of the "feature" that when you reorder rows (for printing for example) you will find that hidden rows to the left don't reorder.

An autosave would have been useful in that case.
PAQed - no points refunded (of 500)

Community Support Moderator

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
I had a document open for a few days not saved. In fact it was called Document 3.  Just a little while ago I started writing something very important in file.  I closed it by accident and when it said, " do you want to save?" I put "no"  and it was gone.
However the file was literally open as Documet 3 for days. I find it hard to believe I cannot retrieve it.  I have made my way into the temp file area and there are several files that match the date and time but How do you open files that have a tmp extension?
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
Microsoft Office

From novice to tech pro — start learning today.