We help IT Professionals succeed at work.

Enable an Excel add-in that has already been installed via Group Policy (GPO)

4,026 Views
Last Modified: 2015-05-05
I am having a hard time figuring out how to simply force enable an add-in in Excel 2010. My current situation is that we have an Excel add-in that is installed on half of our corporate laptops. The add-in is essential to have enabled for the users that have it installed. The problem is, some users are disabling the add-in for random reasons. We would like to create a GPO that forces the add-in to be enabled and does not allow them to disable it. I cannot find this option in Group Policy Manager. This is what I am looking to accomplish.

1. For users that have the add-in installed already, provide a GPO that will enable the add-in and lock it down from being disabled.
2. For users that do not have the add-in installed, do nothing. (I am hoping that it doesn't throw an error if the add-in doesn't exist)
3. Create a REG file that will remove the GPO in case IT needs to troubleshoot with the add-in disabled. (this is just a separate file that we will keep on a shared drive in case it is needed)

The add-in is a XLAM file. I cannot find any policy setting within User Configuration --> Policies --> Administrative Templates --> Classic Administrative Templates --> Microsoft Excel 2010.

Any help would be greatly appreciated.
Comment
Watch Question

Systems Engineer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
You can do this remotely by using GPP and referencing the registry of a workstation with the proper registry setting as list by Raymond Peng the deploy it out the the remaining user's/workstations

Author

Commented:
Thank you for your responses. I am looking to do this for Office 2010 though. I found it for Office 2013. Is there any documentation for 2010? I cannot find the same setting for Excel in 2010 via GPO.
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION