Backups default

  • Thread starter Thread starter Ron Patterson
  • Start date Start date
R

Ron Patterson

How can I configure Excel so that when it opens to a new file (Book 1.xls)
that the new file I create from there, and save, is defaulted to 'Always
Create Backups' and that a backup is automatically created of this new file
and of course subsequently created as I edit and save this file. There is
probably a default file of Book 1.xls somewhere that controls this?
Ron
 
The default template exists internal to XL unless you create a new one.

Create a new workbook, configured the way you want it (# sheets,
formatting, etc.). Save it as a *template* in the XLStart folder
(location varies with version), with the name "Book.xlt". Be sure to
select the options in the Save As dialog to always make backup.

From now on, any New Workbook you create will use that workbook as a
template, including the make backup setting.
 
Create a workbook with every setting you want--always create backup checked,
maybe page layout, headers/footers???

Then save it as book.xlt (as a template) in your XLStart folder.

Then when you click on the new icon, that new workbook will inherit all those
settings from that template.

ps. If you create a template workbook named Sheet.xlt and store it in the same
folder, that one will be used when you add new worksheets to existing workbooks.
 
Ron

Save a workbook as book.xlt (Excel template) to the xlStart folder with the
option to 'always create a back-up' set. This way any new book opened in
Excel will have this setting

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Thank you Nick, JE & Dave
I have followed your instructions and it works perfectly (I think).
Can we agree the program is supposed to work as follows:

New Document:
If you create a new document and name it and save it once, no
backup copy is made.
If you save it twice an exact backup copy is made.
Editing existing document:
If you edit an existing document and save it once, the existing
backup copy is not updated.
You must save it twice to update the existing backup copy.
Thanks much,
Ron
 
I created a new workbook and saved it as testbook1.xls.

I saved it again and a new file was created named: Backup of testbook1.xlk

I opened windows explorer and deleted that Backup of testbook1.xlk file.

I saved the testbook1.xls and I got another backup created.

I'm not sure how that fits in with your second description--but you could do
your own experiments and see how it works for you.
 
Back
Top