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?

Figured out powershell script that does what I want.

 $excel = New-Object -comobject excel.application

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


Answer Summary:
0 Comments   [ + ] Show Comments


Please log in to comment



Are you using updated OCT files?

Please walk through the following video


Answered 06/15/2012 by: jagadeish
Red Belt

  • 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.
  • You can download the latest version of the OCT and .opax settings files from the Microsoft Download Center

    Have you tried editing Config.xml file to select those Excel Addins

  • looks like using config xml will do it. will see how far I can get with that.
Please log in to comment
Answer this question or Comment on this question for clarity