Enable All Data Connections in Office 2007

[PreviousPoster]

Hello,

We are running Server 2003 on the back-end and clients are using Office 2007 on the front-end.

I installed the Office 12 ADM templates, but for the life of me cannot see any option to Enable Data Connections for Access, Excel, PowerPoint, etc.

I want to enable it such that the users are never prompted to allow or deny an access connection - I want the connection to always be allowed. However, I don't see any such option to configure. Am I missing something?

Thanks!

[PreviousPoster]

I found the solution to my problem. A round-about search on Google yielded a custom ADM Template that accomplished exactly what I needed. Here is the template if anyone else runs into this problem:

CLASS USER

CATEGORY "Custom Office 2007 settings"
POLICY "Enable all Data Connections - Excel"
KEYNAME "Software\Microsoft\Office\12.0\Excel\Security "
VALUENAME "DataConnectionWarnings"
VALUEON NUMERIC "0"
VALUEOFF NUMERIC "1"
END POLICY
END CATEGORY

CATEGORY "Custom Office 2007 settings"
POLICY "Enable automatic update for all Workbook Links - Excel"
KEYNAME "Software\Microsoft\Office\12.0\Excel\Security "
VALUENAME "WorkbookLinkWarnings"
VALUEON NUMERIC "0"
VALUEOFF NUMERIC "1"
END POLICY
END CATEGORY


I extrapolated this a bit further by adding additional keys for PowerPoint, and Access which seems to be working just fine.

You need to import it into User Configuration - Administrative Templates. One critical note is to right-click Administrative Templates - View - Filtering and uncheck any checkboxes. If you don't do this, you will not see any of the settings when viewing the template in GPMC.