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

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.
prologic08Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raymond PengSystems EngineerCommented:
There are two reg keys that you'll need

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins

I would go to a machine that has it enabled and export the keys with the addin you want and run it in conjunction with GPO

I've provided the link as a guide to how to force enabling of addins

https://support.microsoft.com/en-us/kb/2733070
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
compdigit44Commented:
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
0
prologic08Author 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.
0
compdigit44Commented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.