IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    PI09135

  • Reported component name

    TM1 PERSPECTIVE

  • Reported component ID

    5724W49PE

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-01-08

  • Closed date

    2014-02-27

  • Last modified date

    2014-02-27

  • 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



Document information

More support for: Cognos TM1
TM1 Perspectives

Software version: 10.2

Reference #: PI09135

Modified date: 27 February 2014