My Oracle Support Banner

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 to [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( to 11g(


To view full details, 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 a vibrant support community of peers and Oracle experts.