After Installing AXE excel add-in (COM Add-in), Excel spread sheet does not display Axe Add-in

Problem: After Installing AXE excel add-in (COM Add-in), Excel spread sheet does not display Axe Add-in.

Solution: Follow the steps mentioned below in sequence,

1. Install AXE (Any COM) Add-in.

2. Check that installed add-in displayed in Add-ins list or not. (Navigation: File> Options> Add-ins> You will see view and manage add-ins window on the right hand right (View will display the list of Active, Inactive and Document related Add-in)

Procedure to install/Uninstall COM add-in

Add a COM add-in

1. Click the File tab, click Options, and then click the Add-Ins category.
2. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Insdialog box appears.
3. In the Add-Ins available box, select the check box next to the add-in that you want to install, and then click OK.

Tip    If the add-in that you want to use is not listed in the Add-Ins available box, clickAdd, and then locate the add-in.

Remove a COM add-in

1. Click the File tab, click Options, and then click the Add-Ins category.
2. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Insdialog box appears.
3. In the Add-Ins available box, clear the check box next to the add-in that you want to remove, and then click OK.

Note    This removes the add-in from memory but keeps its name in the list of available add-ins. It does not delete the add-in from your computer.

4. To remove a COM add-in from the list of available add-ins and to delete the add-in from your computer, click its name in the Add-ins available box, and then click Remove.

3. After adding COM (Axe) excel add-in, again open excel sheet and check “Does it display added COM (AXE) excel add-in. if not then follow below mentioned procedure.

Check and Update the Registry (RegEdit)

Navigate: Start> Run (enter regedit) and click. Regedit window will open. Expand the HKEY_CURRENT_USER or HKEY_LOCAL_MACHINE> Software> Microsoft> Office>Excel>

After clicking on the excel , you will the following entries on the right side window.

The following table lists the entries under this registry key.

Entry	Type	Value
Description	REG_SZ	Required. A brief description of the add-in.This description is displayed when the user selects the add-in in the Add-Ins pane of the Options dialog box in the Microsoft Office application.
FriendlyName	REG_SZ	Required. A descriptive name of the add-in that is displayed in the COM Add-Ins dialog box in the Microsoft Office application. The default value is the add-in ID.
LoadBehavior	REG_DWORD	Required. A value that specifies when the application attempts to load the add-in and the current state of the add-in (loaded or unloaded).By default, this entry is set to 3, which specifies that the add-in is loaded at startup. For more information, see LoadBehavior Values.
Manifest	REG_SZ	Required. The full path of the deployment manifest for the add-in. The path can be a location on the local computer, a network share (UNC), or a Web server (HTTP).If you use Windows Installer to deploy the solution, append the string |vstolocal (that is, the pipe character | followed by vstolocal) to the end of this path. This ensures that your solution is loaded from the installation folder, rather than the ClickOnce cache. For more information, see Publishing an Office Solution by Using Windows Installer. Note When you build an add-in on the development computer, Visual Studio automatically appends the |vstolocal string to this registry entry.
Warmup	REG_DWORD	Optional. A value that indicates that the .NET Framework and Visual Studio Tools for Office runtime load before an add-in loads and reduce the perceived time to load an add-in. Set the Warmup entry to 1 and use this in conjunction with LoadBehavior entry to reduce the load time for Outlook 2010 add-ins that are deployed by using Windows Installer (.msi). This registry key cannot be set by using ClickOnce.

Update the Load Behaviour value to 3 (default). The application tries to load the add-in when the application starts. This is the default value when you build or publish an add-in in Visual Studio.

If the application successfully loads the add-in, the LoadBehavior value remains 3. If an error occurs when loading the add-in, the LoadBehavior value changes to 2, and remains at 2 after the application closes.

If still it will not work with Office 2010, then Switch to office 2007. It s working fine with Office 2007.