1) Open Excel, 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, then in the dropdown go to COM Add Ins.  The CONNX Excel Add In should be there, if not, it was not installed.  If it is there, but it is unchecked, check it and hit OK, if the CONNX menu item still does not appear, continue troubleshooting with the next steps.

 

2) 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)".  If in doubt, look in the installed programs list and make sure the Runtime is there.  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.

 

3) Does the a machine that the CONNX Excel Add In is installed on have the UAC on?  If so, try running Excel as an administrator by setting the advanced properties on the shortcut or from c:\program files {or x86}\Microsoft Office\Office15{or version}\Excel.exe right click to run excel as administrator.

 

4) In Windows 7 the user must have all the windows and office updates installed for the CONNX Excel Add In to be loaded.  All updates must be installed, in testing, some of the updates require the user to turn off the UAC, and if it was not, then the updates did not get installed.  Even with the the user in the administrator group with the UAC on did not install all the updates in testing.  It was not determined which update exactly made the Excel Add In start working during testing.  Again this is for Windows 7 users.  

 

5) If the CONNX Excel Add In is still not working, check the setting in the registry.  With the UAC 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 loading the add it, it will set this entry to 0.  If the registry entries stay 3 yet the Add In is not loading, it is likely a UAC issue that 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