Webadi Where Excel Opens, But The User Sees Only Default Values Indicating That Macros Have Not Run
Last updated on OCTOBER 04, 2016
Applies to:Oracle Web Applications Desktop Integrator - Version 22.214.171.124 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms