PM77585: ISB Report created using TM1 Perspectives doesn't work when saved as xlsx in Excel 2010

APAR status

• Closed as Permanent restriction.

Error description

• ISB Report created using TM1 Perspectives doesn't work - gets
  corrupt when saved as xlsx.    Sometimes it is necessary to save
  the sheet twice, then reopen and corruption occurs. Cell A1 (TM1
  cell) may disappear and other dimension subsets will not
  function.
  

Local fix

• Save as .xls file instead of .xlsx.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Customer Statement:  This problem results from changes made  *
  * to Excel's handling of OLE controls in newer versions.  If   *
  * you are using the ISB continue to save your sheets in the    *
  * .xls format.  See:                                           *
  * http://www-01.ibm.com/support/docview.wss?uid=swg21660614    *
  ****************************************************************
  

Problem conclusion

• No Intent to 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

Applicable component levels