Upload Fails When Excel References A Formula From External Spreadsheet: Method 'Run' of object "_Application' failed

(Doc ID 2319013.1)

Last updated on NOVEMBER 30, 2017

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Upload fails when an Excel cell has defined a formula which references another/external spreadsheet including a Pivot table.

Setting BNE: Enable OOXML Standard to Yes
Linking to a cell in another Excel spreadsheet  errors with:
Try to upload the data, errors with:

Run-time error '-2147221020 (800401e4)':
Method 'Run' of object "_Application' failed




STEPS TO REPRODUCE
-------------------------
The issue can be reproduced at will with the following steps:
Open a blank Excel .xlsx file - such as test.xlsx
enter data into one of the cells, such as: 100
Save the file on your desktop.

Create a new Web ADI template
  Integrator General Ledger - Journals
  Viewer Excel 2016
  Reporting No
  Layout Functional Actuals - Single
  Content None
Fill in the required data for upload.
In the cell for Dedit, enter: =
Then go to the test.xlsx that you previously created, click on the cell with 100 in it. Click on the enter key and the 100 will populate into the new WebADI template using the formula: =[Test_Book1.xlsx]Sheet1!$A$1
Do the same for Credit column.
Now upload the data and it will error with:
'You must enter a value in either the Debit column or the Credit column '



ADDITIONAL INFORMATION
---------------------------------

This works just fine R12.1.3. But since upgrading to R12.2.6 it doesn't work if the OOXML profile is set to Yes. The template will not allow us to input a formula that references a cell in another spreadsheet. If we set this profile option to No, we can reference an external spreadsheet.

Changes

 Upgrade to 12.2.6

Cause

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