You are here: Help Topics > Introduction to Connector > Loading the Connector Excel add-in as optional [Office 2013 and later]

Loading the Connector Excel add-in (XLL) as optional in Office 2013 and later when Excel runs in /automation -Embedding mode

Note: This topic is only applicable to Microsoft Office 2013 and later.

When using Connector with Microsoft Office 2013 and later, loading the Connector Excel add-in (XLL) can be made optional when Excel runs in /automation -Embedding mode. A registry entry was added to allow for this optional loading.

  1. Navigate to Start | Run.
  2. In the Open field, type regedit.
  3. Click OK. The Registry Editor opens.
  4. In the left pane, select HKEY_CURRENT_USER.
  5. Navigate to HKEY_CURRENT_USER\Software\CaseWare International\CaseWare Connector\Settings.
  6. Right-click anywhere in the white space of the right pane and select New | DWORD (32-bit) Value.
  7. Rename the new value to LoadXLLForAutomation.
  8. Right-click LoadXLLForAutomation and click Modify...
  9. In the Value data field, enter the value 1.
  10. Click OK.
  11. Close the Registry Editor.

The registry settings ensure that the Connector add-in will not automatically load when Excel runs in /automation -Embedding mode.