Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Workgroup Templates (Office 2000 / XP)

    In Office 97, you used to be able to 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 Excel desktops throughout the company to a directory where they could access shared templates.This does not seem to work in Excel 2000 or XP. Does anyone know of a way to point Excel to a shared workgroup template directory without using the workgroup template directory specified in Word? I also want to use tabs (folders) like Word has to identify departments or the type of templates offered and if possible remove the default office template files so they don't show up when you click on File/New. Microsoft just doesn't make it easy to manage templates in a "real world" office environment.

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

    Re: Workgroup Templates (Office 2000 / XP)

    Here's the recommendation under XL 2000 Help (edited):
    <hr>make a custom template available to others by storing the template on a network location ... that is accessible by all users in your group. Then create a shortcut to the folder or template, and have users place the shortcut in their Templates folder.<hr>
    Which will usually be either:
    C:osProfilesuser_nameApplication DataMicrosoftTemplates
    or
    Cocuments and Settingsuser_nameApplication DataMicrosoftTemplates
    or similar.

    I haven't gotten into the issue of Template Tabs, see if MSKB 304486, and child links, helps.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workgroup Templates (Office 2000 / XP)

    Not real practical in a business environment. We have more than 100 templates and 20 workstations. This would require me to setup at least 2000 shortcuts. Actually more if you have to do this by individual user as it is sometimes necessary for people to use someone else's workstation. And without tabs (folders) there is no way to organize templates. This would be like throwing all your files into one directory. I know people do this but it

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

    Re: Workgroup Templates (Office 2000 / XP)

    I agree, though I would expect someone with Administrative rights will not need to do more than setup the additional folders and shortcuts once on the network, then write a batch file to copy the additional subfolders and shortcuts to the 20 users, and have it run on the selected users startup. I could probably do it manually with my team of five people in about an hour, and I don't have any Admin rights (I just have "do this to keep your job" rights!).
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    New Lounger
    Join Date
    Dec 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing Office Templates after installation

    Do you know if there is way to remove the Spreadsheet Solutions tab and Office 97 Templates tab (created from upgrade install) and all other Office templates from the General tab from Excel? Some templates are not actually installed on our workstations but an icon shows up anyway and if you click on one it tries to install it. I would rather get rid of them and clean things up. Very confusing to most of our users.

    I also tried adding a test sub directory to the workgroup template directory specified in Word and dropped an Excel template file and a Word Template file in it and the tab shows up in Excel 2000 and XP. So this issue is resolved.

    Thanks for any advice you may have.

    Darrell

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

    Re: Removing Office Templates after installation

    In the File, New, dialogs, select a template or file within one of the tabs, and then right click the the Properties dialog and look under Location (may not show you the entire path). They will usually be somewhere like:

    C:Program FilesMicrosoft OfficeOfficeTemplates1033
    C:Program FilesMicrosoft OfficeOfficeTemplates<etc.>

    ... but installations vary. Delete the folders you don't want.

    Good luck, it sounds like you have a bit of work to do what you need!
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    New Lounger
    Join Date
    Dec 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Office Templates after installation

    That doesn't seem to work on the templates located in the Spreadsheet Solutions Tab. These are the templates that aren't installed but have an icon for them to initiate installation. I'd like to remove the Spreadsheet Solutions Tab and all its icons if possible.

    Darrell

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

    Re: Removing Office Templates after installation

    I think that's going to require a Registry hack or Office reinstallation. Read the MSKB link I provided above in this thread.
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Removing Office Templates after installation

    Did you install Excel with the Spreadsheet Templates option set to Not Available? If I understand correctly, that should make the tab no longer appear. As to having to create shortcuts, if the templates are placed in folders under the template directory then they should show up in folders with a tab named the same as the folder. Haven't actually tinkered with this myself since 97 and I know some changes were made that caused templates to be a bit more unwieldy, but I think it still works that way.
    Wendell

  10. #10
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Removing Office Templates after installation

    I highly recommend the MS Office 2K or XP Resource kit. At this point - you'll have to either apply system policies or reinstall with an MST file. The resource kit is very useful for either one.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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