PM75503: ERROR 2063 WHEN OPENING EXCEL FILE CONTAINING COMPLEX FORMULA WHICH RESULTS IN A NULL/BLANK VALUE.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • In IBM SPSS Statistics 20 and 21, the end user is returned an
    error
    message (2063) when attempting to open an Excel worksheet
    containing a complex formula which results in a null/blank
    value.
    

Local fix

  • This has been reported to IBM SPSS Statistics development for
    investigation.
    
    This issue will be addressed in an upcoming Fix Pack. Please
    refer to the Fix Pack schedule at
    http://www-01.ibm.com/support/docview.wss?uid=swg21599157 for
    information on upcoming Fix Packs.
    
    As a workaround, copy the worksheet containing this blank/null
    value and paste into a new sheet as values only.
    When importing into SPSS Statistics 21, select the new sheet
    containing the values instead of the original worksheet which
    had the formulas.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This problem occurs on all users of IBM SPSS Statistics 21   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ERROR 2063 WHEN OPENING EXCEL FILE CONTAINING COMPLEX        *
    * FORMULA                                                      *
    * WHICH RESULTS IN A NULL/BLANK VALUE.                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM SPSS Statistics 21 Fix Pack 1.         *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in IBM SPSS Statistics 21 Fix Pack
    1 and future releases.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM75503

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    L00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-22

  • Closed date

    2013-03-14

  • Last modified date

    2013-03-14

  • 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

    SPSS STATISTICS

  • Fixed component ID

    5725A54ST

Applicable component levels

  • RL00 PSN

       UP

  • RL00 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

21.0

Reference #:

PM75503

Modified date:

2013-03-14

Translate my page

Machine Translation

Content navigation