Exporting To MS Excel 2003 From Discoverer 11g Produces Incorrect Macros (Doc ID 1568529.1)

Last updated on JUNE 01, 2022

Applies to:

Symptoms

In 11g version of Discoverer, when using Excel to open an exported workbook having totals, with macros enabled, the following error occurs:


ERROR
-----------------------

The formula you typed contains an error.
 - For information about fixing common formula problems, click Help.
 - To get assistance in entering a function, click Function Wizard (Formulas tab, Function Library group)
 - If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.