Thread: Auto-Save
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Auto-Save

Version prior to Excel 2002 had a real AutoSave which overwrote the workbook
with a save at specified time intervals. Good or bad feature depending on
how you look at it.

Versions since 2000 use Auto Recovery which only creates a timed but
temporary backup file which is deleted when the workbook is closed normally.

Auto Recovery is a safety valve in the event of an Excel crash while a
workbook is open.

Jan Karel Pieterse has an addin called AutoSafe
which doen't alert before saving.

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

(look for AutoSafe.zip)

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.

If you still have access to the AutoSave add-in from Excel 2000 it may work
with 2007................it did work with 2002 and 2003


Gord Dibben MS Excel MVP



On Thu, 14 Aug 2008 06:36:17 -0700, Warren Easton
wrote:

Can anyone help?

In Excel 2000 you could click on Tools and in the Add Ins list set your
worksheets to Auto-Save every 10 minutes or so. I can't seem to find this in
Excel 2007 has it been removed and is there any new way of Auto saving?

Thanks in advance.