Set "ALWAYS CREATE BACKUP" Option

[Abradaxis]

In Excel, I keep setting the "always create backup" in the "save as" tools>options menu, but it keeps on getting erased. How can I automatically produce and keep backups in Word, and Excel on a times basis. Using Windows XP and MS Office Professional components if Office 2000, although I have Office 2007, but have not installed it as yet? Thanks.

 

[T. Valko]

If the file already exists and you then apply that setting, you have to resave the file for that setting to be applied.

--
Biff
Microsoft Excel MVP


In Excel, I keep setting the "always create backup" in the "save as" tools>options menu, but it keeps on getting erased. How can I automatically produce and keep backups in Word, and Excel on a times basis. Using Windows XP and MS Office Professional components if Office 2000, although I have Office 2007, but have not installed it as yet? Thanks.

 

[Gord Dibben]

Always save backup is a workbook-only setting, not a global setting.

In Excel you can create a new workbook template to use as the basis for any
NEW workbook.

Open a new workbook. Customize as you wish including the "always save
backup".

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name
your workbook "BOOK"(no quotes). Excel will add the .XLT to save as
BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button
File>New or CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

I think in Word you would have to alter the Normal.dot document.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

I just now noticed you also wanted a Timed Backup.

This is different from "Always create backup" and is controlled by the
AUTOSAVE add-in in XL2000.

Newer versions do not have this add-in to create timed incremental backups.

Keep your AUTOSAVE.XLA file which will work in newer versions.


Gord