AutoSave

[Guest]

I need help. In Office 2000 Excel, there was a feature that allowed the
spreadsheet to autosave. Is that feature in Excel 2003 and if so, how do you
turn it on?

Thanks.

 

[Eamon]

Is this what you are looking for?



Change the save interval for automatic file recovery

1. On the Tools menu, click Options, and then click the
Save tab.

2. Select the Save AutoRecover info every check box.

3. In the minutes box, specify how often you want your
Microsoft Office program to save files.

Note Do not use AutoRecover as a substitute for regularly saving your work
by clicking Save on the Standard toolbar (toolbar: A bar with buttons and
options that you use to carry out commands. To display a toolbar, click
Customize on the Tools menu, and then click the Toolbars tab.)

Eamon

 

[Guest]

Thank you for your response. What I was looking for was AutoSave which was
an add in that would allow the user to turn on autosave for the document you
are working is automatically saved every so many minutes. This appears to be
the same thing. I will try it. Thanks again.

 

[Dave Peterson]

As an alternative, you may want to consider using Jan Karel Pieterse's addin
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.)

Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.

===
And 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

 

[Guest]

Thank you for your assistance.
--
Tee

Thank you for your response. What I was looking for was AutoSave which was
an add in that would allow the user to turn on autosave for the document you
are working is automatically saved every so many minutes. This appears to be
the same thing. I will try it. Thanks again.