recover an un-saved file

[PeaceHere]

I was working on updating an excel file using office 2007 for many
hours. For some reasons, the new changes were not saved, and the
current version is the one before my lengthy changes. Is there a way
that I can recover this file? I really hate to go through the tedious
process of recreating the file.

 

[PeaceHere]

More info. I've checked the autorecover area, and there is no
file. I've searched files using names and contents, and nothing
shows up.

 

[MartinW]

Hi,

Unfortunately, in this situation it is all gone.
You can't use a recovery tool as there was nothing
saved in the first place, hence nothing to recover.

On the bright side it is a great learning experience,
Save!Save!Save! as you go.

When I am developing a new sheet I click on the save
button every minute or two and every time I make a change
in direction or maybe backstep a bit to do something
slightly different, I do a 'save as' xxxxxxxTrial1, xxxxxxxTrial2,
xxxxxxxTrial3 etc. When I am finished I put all the trials in a separate
directory called Sundry where they will sit for 6 months or more.
I only bother to clean it out when it gets too big and unwieldy.

Forget autosave and auto backup utilities, just teach yourself
good habits.

I know this isn't the sort of info you wanted to hear, unfortunately
it is the info you need to hear.

Best wishes for the future
Martin

 

[etradeguru]

Hi,

Unfortunately, in this situation it is all gone.
You can't use a recovery tool as there was nothing
saved in the first place, hence nothing to recover.

On the bright side it is a great learning experience,
Save!Save!Save! as you go.

When I am developing a new sheet I click on the save
button every minute or two and every time I make a change
in direction or maybe backstep a bit to do something
slightly different, I do a 'save as' xxxxxxxTrial1, xxxxxxxTrial2,
xxxxxxxTrial3 etc. When I am finished I put all the trials in a separate
directory called Sundry where they will sit for 6 months or more.
I only bother to clean it out when it gets too big and unwieldy.

Forget autosave and auto backup utilities, just teach yourself
good habits.

I know this isn't the sort of info you wanted to hear, unfortunately
it is the info you need to hear.

Best wishes for the future
Martin






- Show quoted text -

If you dont want to use Autosave / Autorecover , why dont you set a
system timer and remind yourself?
See http://www.cpearson.com/excel/OnTime.aspx for guidance.
If you havent already, make Chips' site a bookmark in your web
browser.
Mark

 

[PeaceHere]

Unfortunately, in this situation it is all gone.
You can't use a recovery tool as there was nothing
saved in the first place, hence nothing to recover.

I thought the autosave feature would save the files for me, under a
different name with .xar as extension. Those files are now gone.
I've tried to use a couple of undelete programs to recover those
files, but none can see those files to start with.

 

[PeaceHere]

If you dont want to use Autosave / Autorecover , why dont you set a
system timer and remind yourself?

I have autosave turned on all along. I just can't recover those saved
files.

 

[Dave Peterson]

You're confusing xl2002+ Autorecovery with xl2k (and below) AutoSave.

Just some background:

xl2k and below came with an optional addin called AutoSave.xla. It could be set
to save every x minutes (user selectable). And it just saves the file at those
intervals.

xl2002+ comes with something called autorecovery. It's also optional, but if
the user turns it on, it saves a copy of that workbook in a special location
(also user selectable). If windows or excel crashes, then the next time excel
opens, it notices that there's a file in that location. Excel prompts the user
to see if he/she wants to recover that file that was saved when excel/windows
crashed.

This autorecovery feature isn't used for the same purpose as AutoSave.

You may be interested in an addin that Jan Karel Pieterse (works in any version)
called AutoSafe (note spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

If you really want autosave...

Gord Dibben posted this:

Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
If you have a previous copy, move it to your Office\Library.
To download the 97 version see here........
http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

==
I've never tried it in xl2007. If you're using xl2007, you may want to do some
testing before you rely on it.

 

[emma]

You're confusing xl2002+ Autorecovery with xl2k (and below) AutoSave.

Just some background:

Thank you, Dave, for a thorough explanation of how these features
work. The autosafe definitely sounds interesting.

My current urgency is to recover those files autosave or autorecovery
have saved for me. As I mentioned, I've tried 2 undelete program,
one is called restoration, and the other is called "GetDataBack".
Neither can see the files deleted by excel.

Does anybody have a recommendation?

 

[Peo Sjoblom]

I think they are gone, there are simply no files to recover unless you have
unlimited resources


--


Regards,


Peo Sjoblom

 

[Dave Peterson]

If you want to spend money to try commercial data recovery services, turn off
the pc that has the harddrive that stored those files you want to try to
recover.

Windows may write over the files with anything it wants.

Then search (on another pc) for one of those data recovery services. But like
Peo suggested, have your credit card handy. I bet they're expensive to the
typical human--maybe not too expensive for a company (or Warren and Bill).