Error Opening Excel File Exported From Discoverer 11g (wrong Code In Macros) (Doc ID 1517387.1)

Last updated on FEBRUARY 21, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.4.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

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(11.1.1.4.0+)

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