Office 2013, enable Power Pivot, Group Policy, howto?

We are about to push Office 2013 to several Windows 7 users.  There are a select few who need Power Pivot and I want to push this either thru GPO or preconfigured with the OCT (office customization toolkit).

What is the best way to push this addon to these users?

Environ is Windows Server 2008 STD DC, Windows 7 machines and Office 2013.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Rainer JeschorCommented:
not 100% sure but I would use GPO for this - as there should only be two registry entries being set for enabling Power Pivot add-in.

Just my 2ct
crp0499CEOAuthor Commented:
Wonder where those are?  :)
Rainer JeschorCommented:
in the ADMX template they are here:
Block all unmanaged add-ins
This policy setting blocks all add-ins that are not managed by the "List of managed add-ins" policy setting.If you enable this policy setting, and the "List of managed add-ins" policy setting is also enabled, all add-ins are blocked except those that are configured as 1 (always enabled) or 2 (configurable by the user) in the "List of managed add-ins" policy setting.If you disable or do not configure this policy setting, users can enable or disable any add-ins that are not managed by the "List of managed add-ins" policy setting.

List of managed add-ins
This policy setting allows you to specify which add-ins are always enabled, always disabled (blocked), or configurable by the user. To block add-ins that are not managed by this policy setting, you must also configure the "Block all unmanaged add-ins" policy setting.To enable this policy setting, provide the following information for each add-in:In "Value name," specify the programmatic identifier (ProgID) for COM add-ins, Excel Automation add-ins, and RTD add-ins, or specify the file name of Excel XLL add-ins and Excel add-ins.To obtain the ProgID for an add-in, use Registry Editor on the client computer where the add-in is installed to locate key names under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins or HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins.To obtain the file name of an add-in, click the File menu in the application where the add-in is installed. Click Options, click Add-ins, and then use the Location column to determine the file name of the add-in.You can also obtain the ProgID or the file name of an add-in by using Office Telemetry Dashboard.In "Value," specify the value as follows:To specify that an add-in is always disabled (blocked), type 0.To specify that an add-in is always enabled, type 1.To specify that an add-in is configurable by the user and not blocked by the "Block all unmanaged add-ins" policy setting when enabled, type 2.If you disable or do not enable this policy setting, the list of managed add-ins is deleted. If the "Block all unmanaged add-ins" policy setting is enabled, then all add-ins are blocked.

Additional info about the registry keys can be found here:


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
crp0499CEOAuthor Commented:
If I could give you more than 500 points I would.  That's the best and most complete answer I've ever received on EE.

Thank you.
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 Office

From novice to tech pro — start learning today.