Save while I work
 

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

Save while I work
 

You are right. Auto recovery option is meant for recovering from problems...

I don't have access to Excel 2003 now so can no test but I recall that
functionality was same in Excel 2003... if you auto saved and quit without
saving you got your original file back...

Of course you can have a macro 'auto saving' then you will have the last
save back...


"turp2tri" wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

Save while I work
 

AutoSave add-in has not been available since Excel 2000 version.

Jan Karel Pieterse has an addin called AutoSafe
which doen't alert before saving.

http://www.jkp-ads.com/download.asp

(look for AutoSafe.zip) download version 3.5

It doesn't overwrite the existing workbook when it saves. It saves a timed
copy 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.

If you still have access to the AutoSave add-in from Excel 2000 I believe it
does work with 2007................it works with 2002 and 2003

I can send you a copy of Excel 97 AutoSave add-in which I know works well
with 2003 version.

Note: you can FileSave AsToolsGeneral OptionsAlways create a backup
which will leave you with a *.XLK file that is always one version behind the
current workbook.


Gord Dibben MS Excel MVP

On Fri, 7 Nov 2008 11:03:02 -0800, turp2tri
wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

Save while I work
 

Autorecovery was added in xl2002 and autosave.xla was removed.

But if you still have a copy of the autosave.xla from xl97 or xl2k, then they'll
work with xl2002+.

turp2tri wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

--

Dave Peterson

Save while I work
 

ps.

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

turp2tri wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

--

Dave Peterson

Save while I work
 

Unfortunately that link seems to have been removed.

I can't get in amymore.................gateway timeout.


Gord

On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson
wrote:

ps.

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

turp2tri wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

Save while I work
 

That's too bad.

Maybe the OP still has access to the older version of Office.

Gord Dibben wrote:

Unfortunately that link seems to have been removed.

I can't get in amymore.................gateway timeout.

Gord

On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson
wrote:

ps.

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

turp2tri wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

--

Dave Peterson

Save while I work
 

I did offer to send a copy of the Excel 97 autosave add-in.

See what transpires.


Gord


On Fri, 07 Nov 2008 16:34:55 -0600, Dave Peterson
wrote:

That's too bad.

Maybe the OP still has access to the older version of Office.

Gord Dibben wrote:

Unfortunately that link seems to have been removed.

I can't get in amymore.................gateway timeout.

Gord

On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson
wrote:

ps.

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

turp2tri wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

Save while I work
 

I didn't notice that.

That's nice of you.

Gord Dibben wrote:

I did offer to send a copy of the Excel 97 autosave add-in.

See what transpires.

Gord

On Fri, 07 Nov 2008 16:34:55 -0600, Dave Peterson
wrote:

That's too bad.

Maybe the OP still has access to the older version of Office.

Gord Dibben wrote:

Unfortunately that link seems to have been removed.

I can't get in amymore.................gateway timeout.

Gord

On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson
wrote:

ps.

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

turp2tri wrote:

I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery
functionality that only works after loos of power, etc) and I could close the
file without manually saving changes as I worked and know that if I re-opened
it, I would have the version that was "auto-saved" 5 minutes ago. Is that
capability gone or am I missing how to do it in 2007?
Thanks.

--

Dave Peterson