"auto save"?

[Shhhh]

Hello all...

Is it possible to tell excel to save my worksheet automatically. either
daily at a specific time or hourly or anything like that? My work network is
incredibly unstable and tends to go down often. It gets very difficult to
work on something with the threat of it dying down constantly.

Any thoughts?

Thank you,
Shhhh

 

[Roger Govier]

Hi

Tools>Options>Save>Set the number of minutes you require for Save
Autorecover

 

[JE McGimpsey]

Check out Jan Karel Pieterse's Autosafe:

http://www.jkp-ads.com/download.asp

(In article <[email protected]>,

 

[Bill Ridgeway]

Roger's suggestion is far better than saving once a day (manually or
automatically). Who's to know that the system will fail one minute before
the due time or even (worse still) during the save. The downside of saving
very frequently is that the hard drive becomes littered with backups.
Whilst it may be prudent to save every N minutes it would also be prudent
(every day) to delete the backup files of N days ago.

Regards.

Bill Ridgeway
Computer Solutions

 

[Earl Kiosterud]

Shhh,

There is said to be an Autosave add-in (Tools - Add-ins), at least in
Excel97 and 2000 (http://support.microsoft.com/kb/213943). I don't see it in
Excel 2002 here, though some of my add-ins have gotten broken. I generally
don't recommend the use of autosave. It overwrites your saved workbook when
it kicks in. I don't know if it gives you a prompt at that time or not, but
there are times for a while when you don't want to save a workbook.

You speak of saving at a specific time. That sounds more like a backup,
which is a copy of a file that's kept in case the original is lost, and
would be done outside of Excel.

You say your network goes down frequently. At those times, you won't be
able to get access to your workbook anyway if you keep it on a network
drive. If you save to your local drive, then you won't be dependent on the
network, but then others won't have access to your changes.

There is an autorecover feature that keeps a recent copy of your workbook.
It's kept behind the scene, and only gets seen when Excel has crashed and
been restarted. It has no effect on your normal saved workbook. It's a
good thing. You can specify how often an autorecover copy is created with
Tools - Options - Save.