Automatically Save

  • Thread starter Thread starter Richard Williams
  • Start date Start date
R

Richard Williams

Is there any way to cause an open spreadsheet to save
itself on a regular basis? This question is separate and
apart from the auto-recover save feature; I want to "hard-
save" a file routinely & automatically without human
intervention. Any thoughts?
 
There is an add-in called autosave in version 97. It can drive you bonkers
because when it kicks in, you can be temporarily stopped from working. I
don't see this add-in in Excel 2002. HTH

Gilles Desjardins
 
-----Original Message-----
Is there any way to cause an open spreadsheet to save
itself on a regular basis? This question is separate and
apart from the auto-recover save feature; I want to "hard-
save" a file routinely & automatically without human
intervention. Any thoughts?
.
under the tools option, select autosave and then set
Click to expand...
according to how often you want excel to autosave
 
Thanks all for the responses. I am running Excel 2002. I
do not see any Auto Save (apart from the Autorecover-
related save) features under either Tools menu,
Tools/Option menu, or in the Add-Ins. Is anyone familiar
with how to address this in Excel 2002?

Thanks again...
 
The autosave from xl97 or xl2k still works with xl2002. So if you can get your
hands on a copy of that addin, you'll be set.
 
Richard Williams said:
Thanks all for the responses. I am running Excel 2002. I
do not see any Auto Save (apart from the Autorecover-
related save) features under either Tools menu,
Tools/Option menu, or in the Add-Ins. Is anyone familiar
with how to address this in Excel 2002?

Thanks again...
Click to expand...

Check out Jan Karel Pieterse's Autosafe facility in

http://www.bmsltd.co.uk/MVP/Default.htm


-Cube
 
I think Jan Karel's autosafe is a lot more like autorecovery than autosave.

From that site:

.....This Autosafe utility creates copies of open workbooks at regular intervals
in a separate (user-selectable) directory.

It does not overwrite the master file(s), that is up to the user to do, using
normal methods. As soon as a workbook is closed the backup copy is deleted from
the backup directory. If an abnormal termination of Excel occurs, the backup
copies remain on disk, and Autosafe finds them the next time Excel is started
and presents recovery options to the user.
 
Back
Top