Solved

Enable Office 2007 Add-Ins for All Users

Posted on 2010-11-30
6
1,234 Views
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?

Thanks,
Ithizar
0
Comment
Question by:Ithizar
  • 3
  • 3
6 Comments
 
LVL 20

Expert Comment

by:pari123
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.)
0
 

Author Comment

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

Accepted Solution

by:
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.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Ithizar
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.
0
 
LVL 20

Assisted Solution

by:pari123
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)
0
 

Author Closing Comment

by:Ithizar
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!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article will show you how to use shortcut menus in the Access run-time environment.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now