ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I get excel 2003 to automatically save my files? (https://www.excelbanter.com/excel-discussion-misc-queries/148554-how-can-i-get-excel-2003-automatically-save-my-files.html)

rhhubie

How can I get excel 2003 to automatically save my files?
 
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


FloMM2

How can I get excel 2003 to automatically save my files?
 
rhhubie,
Select "Tools", "Options".
Select the "Save" tab.
Fill out the data.
hth
:-)

"rhhubie" wrote:

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


Dave Peterson

How can I get excel 2003 to automatically save my files?
 
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

rhhubie wrote:

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


--

Dave Peterson

challa prabhu

How can I get excel 2003 to automatically save my files?
 
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

"rhhubie" wrote:

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


Dave Peterson

How can I get excel 2003 to automatically save my files?
 
This will not save the file that's being changed. This will create a recovery
file that will be used if excel crashes.



challa prabhu wrote:

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

"rhhubie" wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com