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:

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

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