Page 1 of 3 123 LastLast
Results 1 to 15 of 33
  1. #1
    Star Lounger
    Join Date
    Jun 2004
    Location
    Gtr London, England
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Template in XLstart (Windows XP/Office 2003)

    Hi

    I'm having a nightmare with Excel !!!

    I have an xlt file (Branding.xlt) which I would like to reside in XLstart. If I place the file in XLstart and open Excel, it physically opens Branding.xlt rather than a new workbook. If I then go to save it directs me to the XLstart directory. Can you tell me if I'm doing something wrong?

    Many thanks
    Jack

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 5 Times in 5 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    That's what XLStart is for; for Excel to open the files it contains on startup. For your template to be treated as a standard template, you need to use the template location specified by Application.TemplatesPath (or Application.NetworkTemplatesPath). In default Office 2000, XP, and 2003 installations Application.TemplatesPath is usually:

    Cocuments and Settings<username>Application DataMicrosoftTemplates
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    The XLStart folder is meant for files that you want to be opened each time you start Excel. If you want to make Branding.xlt available for use in General Templates (in the New Workbook task pane), you must store it in your user templates folder. The default location for user templates is Cocuments and Settings<username>Application DataMicrosoftTemplates. You can view and edit this location in Word: select Tools | Options..., activate the File Types tab and double click User Templates. The User Templates path should not point to XLStart!

  4. #4
    Star Lounger
    Join Date
    Jun 2004
    Location
    Gtr London, England
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    Hans

    I have specific chart colours and formating held within the Branding.xlt template. I would like the formatting to be available for all workbooks created, hence, my thinking was to place the template in XLstart, to allow global access. I originally had the template held in the appropriate folder so users could just launch the template but rather than relying on the user, I wanted to force the formatting.

    Any ideas?

    Many thanks
    Jackie

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

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    If you rename the template to Book.xlt and place it in XLStart, it will not be opened, but be used as template for a blank new workbook, both when Excel starts and when the user clicks the New button on the toolbar. If you create a copy of it with just one worksheet, name the copy Sheet.xlt and place it in XLStart, it will be used when the user selects Insert | Worksheet.

  6. #6
    Star Lounger
    Join Date
    Jun 2004
    Location
    Gtr London, England
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    Hi Hans

    Have followed your directions and I'm still finding that the template is physically opening. If I rename the template to "Book.xlt", when opening Excel, Book.xlt opens. If I copy Book.xlt and save as Sheet.xlt - both templates open !!! Am I doing something wrong !!!

    Thanks
    Jack

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

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    The names are language-specific. For the English version of Excel, the MUST be Book.xlt and Sheet.xlt. For other languages, they are different. For the Dutch version, they are Map.xlt and Blad.xlt, for example. Do you happen to use a non-English version of Excel?

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    Could you post the entire path to the xlstart folder?

    BTW: this behaviour is not as it should be.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 5 Times in 5 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    Hans, shouldn't those files in the XLSTART folder be renamed to "*.XLS" files?
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    Star Lounger
    Join Date
    Jun 2004
    Location
    Gtr London, England
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    Definitely an English version of Office 2003.

    Regards
    Jack

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 5 Times in 5 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    If you want to impose certain fonts, styles, etc., per your <post#=435481>post 435481</post#>, wouldn't you want them to open?
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    Star Lounger
    Join Date
    Jun 2004
    Location
    Gtr London, England
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    The filepath is:

    C:Program FilesMicrosoft OfficeOFFICE11XLSTART

    I have tried to send the file but the site does not allow xlt files to be uploaded.

    Many thanks
    Jack

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

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    No, I have always learned that they must be templates. From the online help for Excel 2002:
    <hr>default workbook template: The Book.xlt template that you create to change the default format of new workbooks. Excel uses the template to create a blank workbook when you start Excel or create a new workbook without specifying a template.) is usually located at C:Program FilesMicrosoft OfficeOffice10XLStart.<hr>

  14. #14
    Star Lounger
    Join Date
    Jun 2004
    Location
    Gtr London, England
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    I would like the template to run in the same way as Normal.dot does in the Word environment. Rather than the user physically running the template I would like the formatting to be forced.

    Regards
    Jack

  15. #15
    Star Lounger
    Join Date
    Jun 2004
    Location
    Gtr London, England
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template in XLstart (Windows XP/Office 2003)

    For your information, I have changed the name extension and still have the same problem.

    Regards
    Jack

Page 1 of 3 123 LastLast

Posting Permissions

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