Set "ALWAYS CREATE BACKUP" Option

  • Thread starter Thread starter Abradaxis
  • Start date Start date
A

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.
 
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.
 
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
 
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
 
Back
Top