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

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 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