A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Set "ALWAYS CREATE BACKUP" Option



 
 
Thread Tools Display Modes
  #1  
Old February 9th, 2010, 06:52 PM posted to microsoft.public.excel.worksheet.functions,microsoft.public.office.setup,microsoft.public.word.newusers
Abradaxis
external usenet poster
 
Posts: 28
Default Set "ALWAYS CREATE BACKUP" Option

In Excel, I keep setting the "always create backup" in the "save as" toolsoptions 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.
  #2  
Old February 9th, 2010, 07:12 PM posted to microsoft.public.excel.worksheet.functions,microsoft.public.office.setup,microsoft.public.word.newusers
T. Valko
external usenet poster
 
Posts: 15,759
Default Set "ALWAYS CREATE BACKUP" Option

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


"Abradaxis" wrote in message ...
In Excel, I keep setting the "always create backup" in the "save as" toolsoptions 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.
  #3  
Old February 9th, 2010, 07:25 PM posted to microsoft.public.excel.worksheet.functions,microsoft.public.office.setup,microsoft.public.word.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Set "ALWAYS CREATE BACKUP" Option

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".

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...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



On Tue, 9 Feb 2010 12:52:45 -0500, "Abradaxis"
wrote:

In Excel, I keep setting the "always create backup" in the "save as" toolsoptions 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.


  #4  
Old February 9th, 2010, 07:48 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Set "ALWAYS CREATE BACKUP" Option

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


On Tue, 09 Feb 2010 10:25:32 -0800, Gord Dibben gorddibbATshawDOTca wrote:

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".

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...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



On Tue, 9 Feb 2010 12:52:45 -0500, "Abradaxis"
wrote:

In Excel, I keep setting the "always create backup" in the "save as" toolsoptions 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.


  #5  
Old February 10th, 2010, 08:14 AM posted to microsoft.public.excel.worksheet.functions,microsoft.public.office.setup,microsoft.public.word.newusers
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Set "ALWAYS CREATE BACKUP" Option

A failure to maintain settings stored in the Word data key in the registry, such as this, is a common problem, especially in Word 2003, though it applies to other versions also. It is caused by a minor corruption in the data key. You can either rename the data key and it *should* go away, or you can force the issue with autoopen/autonew macros in the normal template when it *will* go away.

The command line to add to the macros is

Options.CreateBackup = True

http://www.gmayor.com/installing_macro.htm

I suspect it will be similar for Excel.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


"Abradaxis" wrote in message ...
In Excel, I keep setting the "always create backup" in the "save as" toolsoptions 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.
  #6  
Old February 10th, 2010, 05:43 PM posted to microsoft.public.excel.worksheet.functions,microsoft.public.office.setup,microsoft.public.word.newusers
Abradaxis
external usenet poster
 
Posts: 28
Default Set "ALWAYS CREATE BACKUP" Option

Thanks to all for your generous contributions to this problem.
"Graham Mayor" wrote in message ...
A failure to maintain settings stored in the Word data key in the registry, such as this, is a common problem, especially in Word 2003, though it applies to other versions also. It is caused by a minor corruption in the data key. You can either rename the data key and it *should* go away, or you can force the issue with autoopen/autonew macros in the normal template when it *will* go away.

The command line to add to the macros is

Options.CreateBackup = True

http://www.gmayor.com/installing_macro.htm

I suspect it will be similar for Excel.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


"Abradaxis" wrote in message ...
In Excel, I keep setting the "always create backup" in the "save as" toolsoptions 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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.