CONNX Data Integration Suite 14.8.0 | Concepts | Advanced Features of CONNX | CONNX Excel Add-In | Troubleshooting
 
Troubleshooting
If the CONNX Excel Add-In does not appear in the ribbon menu:
Go to File > Options > Add-Ins. In the drop down list, go to Disabled Items. If the CONNX Add-In is there, enable it. If it is not, in the dropdown go to COM Add-Ins. If the CONNX Excel Add-In is still not visible, it was not installed. If it is there, but it is unchecked, check it and click OK.
If the CONNX Excel Add-In still does not appear in the ribbon menu:
Customers using Excel 2007 or 2010 need to use CONNX 12 SP1 build 15160 or higher, because it will install the required "Microsoft Visual Studio 2010 Tools for Office Runtime (x64)." Check in the installed programs list to ensure the Runtime is available. If the CONNX Excel Add-In was installed from the standalone installation with CONNX already installed, the main CONNX installation must be at least build 16063 because prior standalone installs did not have the "Microsoft Visual Studio 2010 Tools for Office Runtime (x64)" installed with it.
Does the a machine where the CONNX Excel Add-In is installed have the UAC on? If so, try running Excel as an administrator.
In Windows 7, the user must have all the Windows and Microsoft Office updates installed for the CONNX Excel Add-In to be loaded. Some of the updates require the user to turn off the UAC.
If the CONNX Excel Add-In is still not visible, check the setting in the registry. With the UAC turned off, open the Registry editor directly and change the LoadBehavior registry setting to 3 (0 is disabled). This might need to be done in both the 64- and 32-bit registries. When Excel tries to load the add-in, if there is a problem with the loading, it will set this entry to 0. If the registry entries are still set to 3, but the Add-In still does not load, it is likely that a UAC issue it is not getting and modifying the registry. The two registry entries are:
HKLM\Software\Microsoft\Office\Excel\Addins\CONNXExcelAddin
HKLM\Software\Wow6432node\Microsoft\Office\Excel\Addins\CONNXExcelAddin