Upload Fails When Excel References A Formula From External Spreadsheet: Method 'Run' of object "_Application' failed
Last updated on JANUARY 29, 2018
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:
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
Layout Functional Actuals - Single
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
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