How can I get excel 2003 to automatically save my files?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running Office for students and home 2003 version. In older versions I
was able to have the excel files automatically save every few minutes. I
can't seem to do that with this version. What am I doing wrong?
Dick
 
In xl2k and below, there was an addin named autosave that allowed you to do just
what you described. In fact, if you still have that addin, you can use it with
xl2002 and xl2003 (not sure about xl2007).

xl2002 replaced autosave with autorecover. This new feature was to recover data
if the system crashed (or excel crashed). Excel would notice that extra file
and offer to open it the next time you opened excel. But it doesn't save the
original file every x minutes like 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
 
Hi,

Do the following:

1. On the Tools menu, click Options.
The Options dialog box is displayed.
2. Click the Save Tab.
3. Under Setting, click Save Auto Recovery info every check box.
4. Type a number in the minutes in the "Save Auto Recovery info every" list
or click the arrow to select a time in minutes.
5. click OK, to accept the settings for this worksheet.

Challa Prabhu
 
This will not save the file that's being changed. This will create a recovery
file that will be used if excel crashes.
 
Back
Top