Knowledge base KB0231

Conflict with Adaptive Insights OfficeConnect in Excel

Problem

think-cell and Adaptive Insights (now Workday Adaptive Planning) OfficeConnect are enabled concurrently in Excel. I seemingly randomly receive one of the following error messages and Excel crashes:

  • CRITICALWITHMSG library\ui\win\safesubclassimpl.cpp(409):APIERR 1400 Invalid window handle.
  • CRITICAL library\ui\win\safesubclassimpl.cpp(239): _ASSERT(0!=lResult)

Cause

Our developers analyzed the issue in detail. According to our analysis, hooking/unhooking issues cause this problem when multiple add-ins are available.

A hook is a mechanism by which a function can intercept events before they reach an application. The function can act on events and, in some cases, modify or discard them. The technique used for hooking by Adaptive Insight OfficeConnect can cause errors when several add-ins are present at the same time. For further details, please see KB0201.

Solution

It is not possible for think-cell to work around this problem. We were already in contact with the Adaptive Insights / Workday Adaptive Planning support team. A solution is not yet available. If you want to ask for a fix, you may contact your Workday Adaptive Planning support and refer to help desk request: #208737: OfficeConnect Add-in compatibility issue with think-cell.

Workaround

To avoid the error from occurring, temporarily deactivate OfficeConnect or think-cell to be able to work with the other add-in.

Share