Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Excels default template location? (Excel 2000>)

    Hi, i've hit a blank.... <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    I am looking for excels default template. This must be the file that allows me to make changes that will affect formatting and general setup. When changed here it affects all workbooks opened in Excel. Where does this file reside?
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excels default template location? (Excel 2000>)

    There is no such file until you create one, or rather two default templates.

    Set up a workbook with all the settings you prefer (page setup, number of worksheets, formatting, etc.). Save it as an Excel template named Book.xlt in your XLSTART folder. The name MUST be Book.xlt for the English language version of Excel. When you create a new workbook not based on a specific template, Book.xlt will be used.
    Also create a workbook with all the settings you prefer, but with just one worksheet. Save is as an Excel template named Sheet.xlt in your XLSTART folder. The name MUST be Sheet.xlt. When you insert a new worksheet into a workbook, it will be based on Sheet.xlt.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excels default template location? (Excel 2000>)

    Thanx Hans. For a moment I got worried, as I could not find the "Blank" template for Excel.
    Your explanation is great! <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    Regards,
    Rudi

  4. #4
    New Lounger
    Join Date
    Sep 2001
    Location
    Michigan USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels default template location? (Excel 2000>)

    After installing a second copy of Win XP, I moved the Book.xlt in XLSTART from the original XP to the new XP. I also moved a file named PERSONAL.xls too. It is a hidden workbook in Book.xlt. I found that when I use Excel within the new XP system, all of my toolbar customizations are missing. In addition, even though my Options specify that the default font is Arial 10 point, Excel opens with a default font of Garamond 12 point. Is there a way to fix this?

    Regards,
    Bill

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excels default template location? (Excel 2000>)

    Customizations are in an XLB file. You can create a minor change to create a new XLB, then find the old one, rename it to match and copy over the other one. I think they are all compatible.

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excels default template location? (Excel 2000>)

    Toolbar customizations are stored in a file with extension .xlb (on my system, with Windows XP and Excel 2002, it is Cocuments and Settings<username>Application DataMicrosoftExcelExcel10.xlb).

    Does your Book.xlt have Garamond 12 set in its Normal style? That would overrule the setting in Tools | Options...

  7. #7
    New Lounger
    Join Date
    Sep 2001
    Location
    Michigan USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels default template location? (Excel 2000>)

    Thanks Hans and Steve. I have things straightened out now.

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •