Automatic Save

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

I know there isn't an automatic save that saves your
document for Excel, but there is a Macro for Word that
will ask you if you want to save your work every few
minutes or just save it automatically. Does anyone know if
there is something like that for Excel? Any help would be
greatly appreciated.

Thanks,
Shane
 
Shane

1. File>Save As>Tools>General Options>"always create backup" will set that
workbook to make a copy of the workbook as an *.XLK file each time the
workbook is saved manually.

No different from previous versions of Excel.

The backup is a version of the workbook one save back from the current save.

2. Autosave, which was discontinued in Excel 2002 overwrote the workbook at
timed increments while you had the workbook open.

Versions 2002 and 2003 have retained the "always create backup" feature but
have replaced Autosave with Autorecovery which is useful only if Excel crashes
while your workbook is open.

The Autosave is no longer available unless you can get a copy from an older
version. My copy from XL97 works just fine on 2002.

Add-ins not available with XL 2002 kb article.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;288118

Gord Dibben Excel MVP
 
Thanks Gord. I appreciate the help, that's exactly what I
was looking for.

Thanks,
Shane

-----Original Message-----
Shane

1. File>Save As>Tools>General Options>"always create backup" will set that
workbook to make a copy of the workbook as an *.XLK file each time the
workbook is saved manually.

No different from previous versions of Excel.

The backup is a version of the workbook one save back from the current save.

2. Autosave, which was discontinued in Excel 2002 overwrote the workbook at
timed increments while you had the workbook open.

Versions 2002 and 2003 have retained the "always create backup" feature but
have replaced Autosave with Autorecovery which is useful only if Excel crashes
while your workbook is open.

The Autosave is no longer available unless you can get a copy from an older
version. My copy from XL97 works just fine on 2002.

Add-ins not available with XL 2002 kb article.
http://support.microsoft.com/default.aspx?scid=kb;EN- US;288118

Gord Dibben Excel MVP
Click to expand...
 
Thanks for the tip on Auto Recovery. We do have that set,
but I wanted something with more control. I like the Auto
Save better than the Auto Recovery. I'm sure there is a
reason, but I can't figure out why they got rid of Auto
Save.

Thanks,
Shane
-----Original Message-----
You can autorecover(you would not loose data in case of comp. error)

Tools/options/SAVE tab/Settings/save auto recovery info
Click to expand...
every 10 min(or whatever min you want)
 
Back
Top