PM79391: READING AN XLSX FORMAT FILE CONTAINING CERTAIN COMPLEX CELLEQUATIONS INTO IBM SPSS STATISTICS 21 FAILS WITH ERROR 2063

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

  • You are using IBM SPSS Statistics 20.0.0.2 or 21 and are
    attempting to import data from an xlsx format Excel file using
    File->Open->Data.  The worksheet you are trying to import
    contains cells with equations continaing the VLOOKUP function
    and cell references to other sheets in the workbook.
    
    The attempt to import this worksheet results in the following
    error:
    
    >Error.  Command name: GET DATA
    >(2063) Error reading information for sheet.
    >* Sheet Name: "test"
    >Execution of this command stops.
    
    This was reported to IBM SPSS Development.
    

Local fix

  • IBM SPSS Statistics should be importing the results of the cell
    equation.  The workaround for now is to open the workbook in
    Excel, select the entire range of data you wish to import --
    including any column header information -- create a new sheet --
    which can be in the same workbook -- and use Edit->Paste Special
    to paste only the Values and Number formats into the new sheet.
    Save the result and then import the new sheet into Statistics
    instead.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users importing MS Excel files                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You are using IBM SPSS Statistics 20.0.0.2 or 21 and are     *
    * attempting to import data from an xlsx format Excel file     *
    * using                                                        *
    * File->Open->Data.  The worksheet you are trying to import    *
    * contains cells with equations continaing the VLOOKUP         *
    * function                                                     *
    * and cell references to other sheets in the workbook.         *
    *                                                              *
    * The attempt to import this worksheet results in the          *
    * following                                                    *
    * error:                                                       *
    *                                                              *
    * >Error.  Command name: GET DATA                              *
    * >(2063) Error reading information for sheet.                 *
    * >* Sheet Name: "test"                                        *
    * >Execution of this command stops.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue has been addressed in Statistics 21 Fix Pack 1.   *
    * Please upgrade to this version.                              *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in Statistics 21 Fix Pack 1.
    Please upgrade to this version.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM79391

  • 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-12-18

  • 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

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

21.0

Reference #:

PM79391

Modified date:

2013-03-14

Translate my page

Machine Translation

Content navigation