My Oracle Support Banner

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 DECEMBER 12, 2019

Applies to:

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


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.