Results 1 to 11 of 11
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excels default template (office XP SP3)

    background:
    Words default template is Normal.dot
    Powerpoints default template is Blank.dot

    We renamed our powerpoint template to Microsoft Offices powerpoint template ie "Blank.dot "
    Now each time powerpoint opens our template is displayed.

    I'm wanting to achieve the same thing in excel to display our workbook template.

    I did a search on the local disk and I couldnt find a Microsoft Office default Excel template. eg named
    Workbook.xlt or Blank Workbook.
    except for the excel tGeneral emplates located in C:Program filesMicrosoft OfficeOffice101033

    I have a feeling the excels default template works differently to Word or Powerpoint <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>
    or do I go about it another way?

    diana

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

    Re: Excels default template (office XP SP3)

    You can set up a workbook with the styles and other formatting that you want, then save it as an Excel template (*.xlt) named Book.xlt in your Excel startup folder (the default location is Cocuments and Settings<username>Application DataMicrosoftExcelXLStart). Excel will use it as a model for all new blank workbooks. You can also save a copy of it with a single worksheet as Sheet.xlt in the same location. This will be used when you select Insert | Worksheet.

    Note: the names *must* be Book.xlt and Sheet.xlt in the English language version of Excel.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels default template (office XP SP3)

    thank you Hans.

    on the local C: drive the files Book.xlt and Sheet.xlt dont exist.

    under the users profile a workbook doesnt exist however a worksheet exists. IHowever dont think this excel template is being used or referenced.
    Cocuments and Settings<username>Application DataMicrosoftExcelExcel10.xlb

    diana

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

    Re: Excels default template (office XP SP3)

    Excel10.xlb is a file that contains some Excel settings, such as toolbar customizations and custom lists.

    If you want a customized "Blank workbook" you must *create* a template named Book.xlt and save it in the XLStart folder. Unlike Normal.dot for Word, this file is not created automatically by Excel.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excels default template (office XP SP3)

    You should also be aware that if your users use the File->New... option from the menus and click Blank Workbook, Excel will ignore the Book.xlt file and use any options set in the Tools->Options area.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels default template (office XP SP3)

    thank you

    yes i created an excel template and placed in a couple of startup directories, however it appeared to ignore my template.
    C:Program FilesMicrosoft OfficeOffice10XLStart
    Cocuments and Settings<username>Application DataMicrosoftExcel

    back to the drawing board

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

    Re: Excels default template (office XP SP3)

    Did you make sure to name the template Book.xlt? It won't work as default template if you give it another name.

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels default template (office XP SP3)

    yes i named the template book.xlt. ill take a look at it again today and see what i can discover

    thank you Hans

    diana

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

    Re: Excels default template (office XP SP3)

    Another point: you must save Book.xlt as a template by selecting Template (*.xlt) in the "Save as type" dropdown at the bottom of the Save As dialog. It won't work if you save as an Excel workbook but change the extension to .xlt - Excel will know the difference.

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

    Re: Excels default template (office XP SP3)

    The path

    Cocuments and Settings<username>Application DataMicrosoftExcel

    should be

    Cocuments and Settings<username>Application DataMicrosoftExcelXLStart

  11. #11
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels default template (office XP SP3)

    Apologies Hans

    yes I meant the path...

    Cocuments and Settings<username>Application DataMicrosoftExcelXLStart

Posting Permissions

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