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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 | |
|
|