Solved

Enable Office 2007 Add-Ins for All Users

Posted on 2010-11-30
6
1,246 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
[X]
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
6 Comments
 
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.)
0
 

Author Comment

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

Accepted Solution

by:
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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: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)
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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.

717 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