Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Calgary, AB Canada
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy

    I am in an office that is looking at going to office 2007, and I am setting some things up for them. One of the things they want is to be able to use custom templates.

    I've gone into Excel 2007 and created the templates. I've put them on a network drive that the users have requested I use. I've gone into Office Button-->Excel Options-->Trust Center-->Trust Center Settings-->Trusted Locations and I've set the "Excel 2007 Default Location: User Templates" to the shared drive after selecting the 'not recommended' option box to allow the setting of a network path.

    However, when I try to create a new document based on User Templates, I get a blank screen that states I need to create the templates by going Office Button-->Save As-->Trusted Templates and then save as a template.

    I can't find this 'trusted templates' thing anywhere. Really. I've looked.

    What am I doing wrong here?

    Any help, guidance, or direction that can be given would be greatly appreciated.

    Thank you.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Calgary, AB Canada
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you for the links. They confirm what I unfortunately suspected: it can't be done.

    But it's nice to know my misery has company.



    Thank you.

  4. #4
    Star Lounger
    Join Date
    Nov 2001
    Location
    Calgary, AB Canada
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='chris_smith' post='762220' date='27-Feb-09 08:36']Thank you for the links. They confirm what I unfortunately suspected: it can't be done.

    But it's nice to know my misery has company.



    Thank you.[/quote]

    As a side note, this IS possible in Word 2007. You set the workgroup template location, and you're good to go. This works great. It's a shame you can't do the same thing in Excel.

    Oh well.


  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='pieterse' post='761847' date='26-Feb-09 12:49']http://www.projectwoman.com/2007/06/changi...t-template.html[/quote]

    Thanks Jan Karel.
    I feel that this link (above) in particular should serve as a warning to anyone contemplating 2007, or dealing with a client using 2007.
    Who ever would have thunk it?!!

  6. #6
    Star Lounger
    Join Date
    Nov 2001
    Location
    Calgary, AB Canada
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No kidding!

    I never would have thought to go to Word to fix Excel. But it works.

    Wonderful link.

    Thank you!!!


Posting Permissions

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