<div>
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?
</div>


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?

<div>
I used your second solution, but I can certainly see where the first would be better.<br />
<br />
Thank you!
</div>


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

Thank you!

<div>
<div class="content wysiwyg-content">
We have an excel xlsm sheet that uses a data connection from our SharePoint 2007 server and has macros.<br />
<br />
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.<br />
<br />
We have a windows server 2003 environment, Active Directory, MOSS 2007.<br />
<br />
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?<br />
<br />
Thank you
</div>
</div>


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

Group Policy for Excel Data Connection/Macros MOSS 2007

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.