[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11633
  • Last Modified:

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!

GSFMedia
0
gsfmedia
Asked:
gsfmedia
  • 3
  • 3
  • 2
  • +4
1 Solution
 
sunray_2003Commented:
I doubt if she can get it back ... which is my first thought.. I need to research on this

Sunray
0
 
sunray_2003Commented:
0
 
sunray_2003Commented:
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
svenkarlsenCommented:
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
 
DreamboatCommented:
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
 
Stevejones123Commented:
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
 
DreamboatCommented:
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
 
svenkarlsenCommented:
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
 
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!
Karen
0
 
DreamboatCommented:
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
 
Stevejones123Commented:
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
 
PashaModCommented:
PAQed - no points refunded (of 500)

PashaMod
Community Support Moderator
0
 
acavalieroCommented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now