FG

Activate Excel Add-Ins as part of Deployment?

Freshabout 19 hours ago
Mar 15, 2026509 views
Confidence Score0%
0%

Problem

I am using the office customization tool to create an unattended installation file for Microsoft Office 2010 pro plus. I have everything setup as I like, except that I need the excel add-ins activated (Analysis ToolPak, Analysis ToolPak - VBA, Euro Currency Tools, Solver.) There is a section of the…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Activate Excel Add-Ins During Office 2010 Deployment

Medium Risk

The Office Customization Tool (OCT) allows for various configurations during the installation of Microsoft Office 2010 Pro Plus, but it does not automatically enable Excel add-ins such as Analysis ToolPak, Solver, and others. This is due to the fact that these add-ins require specific registry entries to be created and set during the installation process.

Awaiting Verification

Be the first to verify this fix

  1. 1

    Create a Custom Configuration File

    Use the Office Customization Tool to create a custom configuration file (config.xml) that specifies the installation settings for Office 2010. Ensure that the Excel add-ins are included in the configuration.

    xml
    <Configuration>
  <Add OfficeClientEdition="32" Channel="PerpetualVL2019">
    <Product ID="ProPlus2010">
      <Language ID="en-us" />
      <ExcludeApp ID="Access" />
      <ExcludeApp ID="Publisher" />
      <AddIn ID="ExcelAnalysisToolPak" />
      <AddIn ID="ExcelSolver" />
      <AddIn ID="ExcelEuroCurrencyTools" />
      <AddIn ID="ExcelAnalysisToolPakVBA" />
    </Product>
  </Add>
</Configuration>
  2. 2

    Modify Registry for Add-Ins Activation

    After the installation, you may need to modify the Windows Registry to ensure that the add-ins are activated. Use a .reg file to automate this process. Create a .reg file with the following content to enable the add-ins in Excel.

    reg
    Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Analysis ToolPak]
"Visible"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Solver]
"Visible"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Euro Currency Tools]
"Visible"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Analysis ToolPak - VBA]
"Visible"=dword:00000001
  3. 3

    Deploy the Configuration and Registry Files

    Deploy the Office installation using the custom configuration file and ensure that the .reg file is executed after the installation completes. This can be done using a batch script or a deployment tool.

    batch
    @echo off
start /wait setup.exe /config config.xml
regedit /s addins.reg
  4. 4

    Test the Installation

    After deployment, open Excel and verify that the add-ins are listed under the 'Add-Ins' menu and are activated. This confirms that the installation and registry modifications were successful.

Validation

To confirm the fix worked, open Excel and navigate to the 'File' menu, then select 'Options' and click on 'Add-Ins'. Ensure that Analysis ToolPak, Solver, Euro Currency Tools, and Analysis ToolPak - VBA are listed and checked as active add-ins.

Sign in to verify this fix

Environment