Error Opening Excel File Exported From Discoverer 11g (wrong Code In Macros)
Last updated on FEBRUARY 21, 2017
Applies to:Oracle Discoverer - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11g]
Information in this document applies to any platform.
When exporting a workbook having calculations to Excel from Discoverer Plus or Viewer 11g, it exports the workbook successfully, but when opening the exported workbook in MS Excel with macros enabled, it gives
the following message in Microsoft Excel and then opens with wrong data in calculation column:
This problem does not occur while using Discoverer Plus or Viewer 10g and works just fine without any errors.
You started getting this problem after upgrading Discoverer from 10g(10.1.2.55.26) to 11g(126.96.36.199.0+)
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