+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Adding trusted location to Excel in Technical; Admin are using Targsats and they have a shared folder on the server so they can all access the data. ...
  1. #1
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,150
    Thank Post
    182
    Thanked 50 Times in 43 Posts
    Rep Power
    25

    Adding trusted location to Excel

    Admin are using Targsats and they have a shared folder on the server so they can all access the data. Basically Targsats is just a collection of Excel files with macros and for some reason Excel keeps freezing when opening the files. The problem looks like a trust issue as when the files are opened from the desktop Targsats works fine.

    So my question is how can I set Excel to trust a network location and not block the macros. Excel 2007 has the add network location in the trust centre but I can't see anything like that in Excel 2003 and I would rather set these options in GP anyway.

    Edit:
    Everything was working fine till the other week and the only thing that's changed is that I installed a Certification Authority on one of the servers.
    Last edited by Jobos; 4th July 2011 at 03:03 PM.

  2. #2
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,150
    Thank Post
    182
    Thanked 50 Times in 43 Posts
    Rep Power
    25
    So Excel 2007 and 2010 trusts can be controlled via GP but I still can't see a way to do this with Excel 2003.

  3. #3
    TheMan100's Avatar
    Join Date
    Dec 2010
    Posts
    156
    Thank Post
    8
    Thanked 15 Times in 15 Posts
    Rep Power
    10
    Can you not create an MSP file for it and configure the trusted location settings, then just apply it to the computers.

  4. #4
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,150
    Thank Post
    182
    Thanked 50 Times in 43 Posts
    Rep Power
    25
    Quote Originally Posted by TheMan100 View Post
    Can you not create an MSP file for it and configure the trusted location settings, then just apply it to the computers.
    Well I've found out why Excel has stopped working Microsoft Office File Validation Add-in slows down Excel 2003 when - Microsoft Answers

SHARE:
+ Post New Thread

Similar Threads

  1. Adding a Trusted Site to Group Policy
    By MaximusR in forum Windows
    Replies: 2
    Last Post: 16th June 2011, 09:39 AM
  2. excel adding problem
    By browolf in forum Office Software
    Replies: 13
    Last Post: 11th June 2010, 09:22 AM
  3. [MS Office - 2003] Adding sound to an Excel spreadsheet
    By leco in forum Office Software
    Replies: 2
    Last Post: 22nd February 2010, 07:59 PM
  4. SLG2 location location location
    By Oops_my_bad in forum MIS Systems
    Replies: 12
    Last Post: 18th June 2009, 11:23 PM
  5. Trusted Publishers
    By woody in forum Windows
    Replies: 4
    Last Post: 1st December 2006, 09:03 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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