Problem:
- I needed to disable a menu item in Excel 2007.
Resolution:
- First of all download the ADM(X) templates for Office 2007 (keep in mind I am using server 2008). You can download them here
- Extract it to a folder, and then copy the contents of the admx folder to C:\Windows\PolicyDefinitions
- Open your Group Policy Editor (gpmc.msc), and make a new Group Policy (I named it “Office GPO”
- If you browse to [User Configuration], [Administrative Templates], you will see all the Office Policy Definitions.
- My task was to disable the Menu Items “From Other Sources”, “Existing Connections” and “Connection”.
You can disable menu items under the group policy setting:
[Administrative Templates\Microsoft Office Excel 2007\Disable Items in User Interface\Custom\Disable Commands\ - The Disable Commands works with ID numbers, you can find these here
For my problem I had to disable ID’s: 11205, 12495 and 12496









Pingback: Kasper de Jonge BI Blog » Disable SSAS access from Excel using group policies