Auto Save in Excel 2003

[Frank]

Does anyone know if there a way to set up Excel to
autosave a spreadsheet periodically? I was able to do it
in an earlier version of Excel through an add in. You
would get a dialog box every [ ] minutes that asked if
you wanted to save the current spreadsheet. I know there
is an autorecover in Excel 2003, but I have not been able
to find the autoSAVE function.

Any help would be appreciated. Thanks.

Frank

 

[Frank Kabel]

Hi
this feature is no longer included in Excel 2003. Excel 2003 has an
automatic recovery mechanism to achieve the same (or better) results

 

[Lady Layla]

You can use the autosave addin that worked for prior versions in xp


: Does anyone know if there a way to set up Excel to
: autosave a spreadsheet periodically? I was able to do it
: in an earlier version of Excel through an add in. You
: would get a dialog box every [ ] minutes that asked if
: you wanted to save the current spreadsheet. I know there
: is an autorecover in Excel 2003, but I have not been able
: to find the autoSAVE function.
:
: Any help would be appreciated. Thanks.
:
: Frank

 

[Dave Peterson]

Short descriptions:

Autosave (an addin in xl versions before xl2002), the workbook gets saved at
user selectable intervals (just like a manual save). (If you're running
xl2002+, then if you can find a copy of autosave, it'll work with that version,
too.)

xl2002+ has a feature called autorecovery. It's used to catch catestrophic
events (excel/windows crashing). But it won't help if you never save or you
close excel normally.

But Jan Karel Pieterse has an addin that's the best of both worlds: 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.

=====
You may want to get a copy of Jan Karel's addin. It might save a few tears in
the future.

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

Does anyone know if there a way to set up Excel to
autosave a spreadsheet periodically? I was able to do it
in an earlier version of Excel through an add in. You
would get a dialog box every [ ] minutes that asked if
you wanted to save the current spreadsheet. I know there
is an autorecover in Excel 2003, but I have not been able
to find the autoSAVE function.

Any help would be appreciated. Thanks.

Frank