Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel template directory (XP)

    In previous versions of Excel, you could set a workgroup templates directory by entering the directory in the Alternate Startup File Location text box on the General Tab of the Tools/Options dialog box. Once you did this, any templates in that directory would show up when you clicked on File/New. This directory could be different from the directory designated as the Word Workgroup template directory. We used this to point all of our Exel desktops throughout the company to a directory where they could access shared templates.This does not seem to work in Excel 2002 (XP). In that version of Office, it seems like you are allowed only one workgroup template directory for all of the Office apps to share. You set it on the Setup Tab of the Customize Office Toolbar dialog box. Even if I do drop the templates into that directory (which appears to default to the Word Workgroup template directory), it does not display the Excel templates. And, it gives me an error for every Word template in that directory when I open Excel. Does anyone know of a way to point Excel to a shared workgroup template directory other than the default Word or Office directory?

    Thanks.

    MCT

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel template directory (XP)

    I don't know of any version of Excel where the Alternate Startup Directory functions as you describe. The Alternate Startup Directory has always been a way to add an additional directory that performs the same function as XLStart. In other words, any files placed there are automatically opened when you start Excel. It is NOT a place to put templates.

    I believe that what you are looking for are the User Templates and Workgroup Templates options that can be set in Word/Tools/Options on the File Location tab. Any directories that you set here should function for all Office products that have templates.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel template directory (XP)

    Actually, the Alternate Startup File Location in Excel (at least in versions 4.0 through 2000) does also add any templates in it to the File/New dialog box, which allows you to base a new worksheet on a template. We have been using this function for years in all our locations. It's just in XP that is doesn't seem to work. Thanks for replying.
    MCT

  4. #4
    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: Excel template directory (XP)

    Hi,
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q302/8/34.ASP>this article</A> on MSKB indicates that this is a known issue. Sadly they only suggest using the Word Workgroup Templates path so I don't know of any solution to your problem, I'm afraid.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Mar 2004
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel template directory (XP)

    Thanks, Rory. I was afraid that was going to be the answer. It seems Microsoft can never leave the things that work great and don't need improving alone.

  6. #6
    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: Excel template directory (XP)

    Hey, it's the new 'features' that make upgrading such a joy, after all! <img src=/S/doh.gif border=0 alt=doh width=15 height=15> <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Try writing a macro to do a PasteSpecial xlColumnWidths and see how far you get....
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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