Solved

Enable Office 2007 Add-Ins for All Users

Posted on 2010-11-30
6
1,233 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

759 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

19 Experts available now in Live!

Get 1:1 Help Now