How To Workaround a Microsoft Office 2013 (and later) Change That Renders DataLens Services for Excel (Add-In) Functionality Inactive in Multiple Excel Workbooks

(Doc ID 2365197.1)

Last updated on MARCH 01, 2018

Applies to:

Oracle Enterprise Data Quality for Product Data - Version 5.6.2 and later
Generic Windows

Goal

The goal of this article is to convey a workaround that will allow the DataLens Services for Excel (Add-In) functionality in multiple Excel Workbooks.

First, it is necessary to understand the change in behavior and the reason for the workaround.

Change and Reason:
Starting in Office 2013, Microsoft introduced a change (in Microsoft Office) that would start subsequent workbooks in the same Excel.exe process (regardless of new or saved Workbooks).  The DataLens Services for Excel (Add-In) or any other Add-In for that matter will be rendered inactive in all but the originally opened Excel Workbook.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms