Office Connector add-in is not present in Microsoft Excel
Description
Cause

You are trying to run an Office Connector Starter report but the add-in for Excel is disabled. The add-in may also appear to be enabled but greyed out.

The Office Connector add-in can be disabled by Excel, often as a result of Excel being ended while Office Connector was actively processing.

Resolution

The steps to resolve this issue will depend on the version of Microsoft Excel being used.

Excel 2007:

  1. Click the Office button and select Excel Options, Add-Ins.
  2. In the Manage list, confirm that Excel Add-ins is selected. Click Go.
  3. Clear the Event 1 Office Connector check box. Click OK.
  4. Select Excel Options, Add-Ins again.
  5. In the Manage list, confirm that Excel Add-ins is selected. Click Go.
  6. Select the Event 1 Office Connector check box. Click OK. (You may need to browse out to C:\Program Files (x86)\Event 1\Office Connector to get the Add-on to be available).

Excel 2010 and higher:

  1. In Excel, go to File, Options, Add-Ins, Manage: Excel Add-Ins, Go.
  2. Click Browse and browse to C:\Program Files\Event 1\Office Connector (or C:\Program Files (x86)\Event 1\Office Connector) and select the OfficeConnector.xla file and click OK.
  3. This issue has been resolved at times by unchecking the Office Connector in Addins and closing Excel. Open Excel and then click the Office Connector Add-In.

Note: For add-ins to be accessible in Excel, at least one workbook needs to be open. The Office Connector toolbar will be unavailable when no workbooks are open. Also, the Add-ins option under Tools is unavailable when there is no workbook open.


[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles