How To Workaround a Microsoft Office 2013 (and later) Change That Renders DataLens Services for Excel (Add-In) Functionality Inactive in Multiple Excel Workbooks
Last updated on MARCH 01, 2018
Applies to:Oracle Enterprise Data Quality for Product Data - Version 5.6.2 and later
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.
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