PM38596: EXPORT REPORT IN EXCEL 2007 FORMAT FAILED WHEN A BOOKMARK ITEM CONTAINS THE AND SIGN "&".

APAR status

• Closed as program error.

Error description

• Customer is getting the following error "The Work Book cannot be
  opened or repaired by Microsoft Excel because it is corrupt"
  when exporting report as Excel 2007 Format. ??the origin of the
  error is the And sign "&" contained in the Bookmark Item. ??The
  Bookmark values is coming from customer Database and contains
  (some of them) the "&" sign. ??workaround  : Use Excel 2002
  Format. ???
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG8 BI COG VIE

• Fixed component ID

  5724W12CV

Applicable component levels

• RA11 PSN

     UP