Solved

Recover Unsaved Excel Document

Posted on 2003-11-26
14
11,605 Views
Last Modified: 2012-08-13
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!

GSFMedia
0
Comment
Question by:gsfmedia
  • 3
  • 3
  • 2
  • +4
14 Comments
 
LVL 49

Expert Comment

by:sunray_2003
ID: 9827002
I doubt if she can get it back ... which is my first thought.. I need to research on this

Sunray
0
 
LVL 49

Expert Comment

by:sunray_2003
ID: 9827008
0
 
LVL 49

Expert Comment

by:sunray_2003
ID: 9827020
HOW TO: Use the Microsoft Office Application Recovery Tool in Office Programs
http://support.microsoft.com/default.aspx?scid=kb;en-us;294933

Sunray
0
 
LVL 9

Expert Comment

by:svenkarlsen
ID: 9827121
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,
Sven
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 9829576
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.
0
 
LVL 2

Expert Comment

by:Stevejones123
ID: 9830881
If it's really important then you can buy a third party recovery tool. You could try with "Lost & Found" from www.Powerquest.com 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.

0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 22

Expert Comment

by:Dreamboat
ID: 9832513
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.
0
 
LVL 9

Expert Comment

by:svenkarlsen
ID: 9832569
GSF,

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,
Sven
0
 
LVL 17

Expert Comment

by:Karen Falandays
ID: 9842138
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!
Karen
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 9842313
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.
0
 
LVL 2

Expert Comment

by:Stevejones123
ID: 9844468
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.
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10371735
PAQed - no points refunded (of 500)

PashaMod
Community Support Moderator
0
 

Expert Comment

by:acavaliero
ID: 14781065
HEEEEELP  
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?
al
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now