/build/static/layout/Breadcrumb_cap_w.png

Load Office 2010 Excel Addins for All Users at Install Time?

I am using the Office Customization tool to setup a customized silent install of office 2010, and although it shows the Analysis Toolpak and Solver as configurable in the Set Feature Installation States section of the OCT, these options are greyed out, and the plugins are not active by default.

Is it possible to script out the activation of these plugins via commandline or registry?

UPDATE:
Figured out powershell script that does what I want.

 $excel = New-Object -comobject excel.application

 $excel.addins | foreach {$_.installed="true"}

 $excel.quit() 


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: jagadeish 11 years ago
Red Belt
3

Are you using updated OCT files?

Please walk through the following video

http://go.microsoft.com/fwlink/p/?LinkId=203127


Comments:
  • updated OCT files? I don't know what you mean.

    I did right click on the addins and select the option to install from computer. However, it does not make the addins active. I am trying to figure out how to activate them via script. - muebel 11 years ago
  • You can download the latest version of the OCT and .opax settings files from the Microsoft Download Center

    http://www.microsoft.com/en-us/download/details.aspx?id=18968
    Have you tried editing Config.xml file to select those Excel Addins

    http://technet.microsoft.com/en-us/library/cc179006 - jagadeish 11 years ago
  • looks like using config xml will do it. will see how far I can get with that. - muebel 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ