asked on 11/9/2010

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 SharePoint Active Directory Microsoft Excel

Last Comment

itkadmin

11/15/2010

ASKER CERTIFIED SOLUTION

Jan Karel Pieterse

11/10/2010

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

itkadmin

11/10/2010

ASKER

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

11/10/2010

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

itkadmin

11/15/2010

ASKER

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

Thank you!