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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 20

Expert Comment

by:Ardhendu Sarangi
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

Ardhendu Sarangi 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.
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now


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

by:Ardhendu Sarangi
Ardhendu Sarangi 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

Office 365 Training for Admins

Learn how to provision tenants, synchronize on-premise Active Directory, and implement Single Sign-On with these master level course.  Only from Platform Scholar

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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…

739 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