My Oracle Support Banner

Upload Fails When Excel References A Formula From External Spreadsheet: Method 'Run' of object "_Application' failed (Doc ID 2319013.1)

Last updated on FEBRUARY 12, 2019

Applies to:

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


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

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 '


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.


 Upgrade to 12.2.6


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.