Avatar of itkadmin
itkadminFlag for Canada asked on

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
Microsoft SharePointActive DirectoryMicrosoft Excel

Avatar of undefined
Last Comment
itkadmin

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jan Karel Pieterse

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
itkadmin

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?
SOLUTION
Jan Karel Pieterse

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
itkadmin

I used your second solution, but I can certainly see where the first would be better.

Thank you!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy