• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 722
  • Last Modified:

Group Policy for Excel Data Connection/Macros MOSS 2007

We have an excel xlsm sheet that uses a data connection from our SharePoint 2007 server and has macros.

I'm getting tired of explaining to people that they have to firse allow the macros and then allow the data connection and the links when they open the spreadsheet.

We have a windows server 2003 environment, Active Directory, MOSS 2007.

Is there a way to set a group policy on the server so that everybody's excel program knows it can trust data connections and macros from our SharePoint site?

Thank you
0
itkadmin
Asked:
itkadmin
  • 2
  • 2
2 Solutions
 
jkpieterseCommented:
You could buy a code signing certificate, sign the macros (then it is just a matter of checking the "Trust all macros from this publisher" checkbox to enable macros in future).

After that, I'd turn off automatic updating of queries and have VBA handle the update.
0
 
itkadminAuthor Commented:
Good idea, but unfortuneately I can't imagine finance authorizing a couple hundred $/yr so people don't have to click a button (this is for a sheet on our network, behind our firewall, so public integrity isn't an issue) . Any other ideas?
0
 
jkpieterseCommented:
You can create your own certificate using selfcert.exe (in your Office setup folder), but it would require each user to install that certificate for it to work.
0
 
itkadminAuthor Commented:
I used your second solution, but I can certainly see where the first would be better.

Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now