PI09135: CANNOT CONVERT EXCEL SHEETS THAT ARE SAVED AS .XLS

APAR status

• Closed as program error.

Error description

• If worksheets were created with excel 2007 or 2010 and saved as
  .xls, it will not convert using the convert excel file tool in
  Architect.??Error in the conversion log shows:?Conversion of
  file.xls (from C:\Users\{user}\AppData\Local\Temp\2\TM193AB.xls
  to C:\Users\{user}\AppData\Local\Temp\2\TM193AB.xlsm) failed,
  error: 0000000D, description: The following defined names are
  invalid for Office 2007 and higher: _xlfn.BAHTTEXT,
  _xlfn.IFERROR. An underscore will be inserted at the
  beginning.?The following defined names are not inserted properly
  into converted workbook: __xlfn.BAHTTEXT,
  __xlfn.IFERROR?Conversion thread ended: 1 files found, 0 files
  converted, 1 files not converted, errors detected
  

Local fix

• Save file as xlsx and re-upload. Conversion of xlsx should succe
  ed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please upgrade to IBM Cognos TM1 10.2 Fix Pack 1 Interim Fix *
  * 1 (10.2.0.1.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

  TM1 PERSPECTIVE

• Fixed component ID

  5724W49PE

Applicable component levels

• RA20 PSN

     UP