Enable Office 2007 Add-Ins for All Users

Posted on 2010-11-30
Last Modified: 2012-05-10
Hi folks!

I work in a school environment with approximately 120 Windows XP Service Pack 3 workstations running Office Enterprise 2007. There is a particular add-in -- in this case, the Solver add-in for Excel -- that I would like to have enabled for all users on all workstations. However, the standard behavior of Office 2007 is that add-ins are installed on a per-user basis.

Is there any good way for me to enable this particular add-in for all users without each user having to enable it individually?

Question by:Ithizar
  • 3
  • 3
LVL 20

Expert Comment

ID: 34239879
If macros are enabled, then take a  look into putting this code...

AddIns("analysis toolpak").Installed = True
AddIns("solver add-in").Installed = True

in an event that is common to all users (Workbook_Open event of a standard worksheet template, Personal.xlsm for each user, etc.)

Author Comment

ID: 34241407
Unfortunately, due to security concerns in this environment, macros are disabled.
LVL 20

Accepted Solution

pari123 earned 250 total points
ID: 34241560
There is a solution provided on the HP forums which worked for the users. Can you try this and see if this works out for you?

"The following solution worked for me to deploy Excel add-in using administrative install for each user without giving them local admin rights:

1) Deploy-installed to all PCs *just once* using an account with local admin rights. Got it to install the add-in at the default location "C:\Program Files\TRIM Context\" instead of installing it every time whenever each user logs on.

2) Now this is the kicker: Add 3 registry keys (pertaining to the add-in in HKCU because the add-in is activated "per-user") to the domain user profile on logon. This ensures the add-in is activated each time the user logs on."

Source: Add-In Install Workaround.
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.


Author Comment

ID: 34241678
I believe I understand. However, how do you get the add-in to install in a specific folder, as the instructions say? There doesn't seem to be that option.
LVL 20

Assisted Solution

pari123 earned 250 total points
ID: 34241799
I have Solver Add-In installed on my PC and here are the registry settings

Within "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options", look at the OPENx subkeys -

I have the following -
OPEN1 = "C:\Program Files (x86)\Microsoft Office\Office14\Library\SOLVER\SOLVER.XLAM"

(Note: The number will differ based on your Office Version, I have Excel 2010 so it is 14.0)

Author Closing Comment

ID: 34244209
Excellent! This method worked perfectly!

For the reference of anyone else who may come along and check out this solution, the registry key for Office 2007 is within HKCU\Software\Microsoft\Office\12.0\Excel\Options.

Thanks for the help!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question