Webadi Where Excel Opens, But The User Sees Only Default Values Indicating That Macros Have Not Run (Doc ID 1937471.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Web Applications Desktop Integrator - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

Only see default values indicating that Macros have not run after migrating from Desktop ADI to WebADI

This can be re-produced with the following steps:
1. Migrating from Desktop ADI to WebADI and when trying to view the output of a report in Excel:
Navigation: Report Manager > View Requests > Completed Requests > Output > View Report Now > Output Type (Excel) > Click Yes (ActiveX prompt)
2. The result is that Excel opens but the user sees only default values indicating that Macros have not run.

Notes:
The Desktop Platform is:Windows 7 Enterprise SP1, Office 2007 Sp3, Internet explorer 9 (all 32 bit).
The user confirms that the following (required) configuration has been completed:
a) IE: Set "Initialize and script ActiveX controls not marked as safe for scripting" to "Prompt".
b) Excel: 'Disable all macros with notification' is checked.
c) Excel: 'Trust Access to the VBA project object model' is checked.

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