Solution for “SPSS Error Code 2063 Getting Data”

Hello all.

Just troubleshot (haha) my way out of an SPSS issue, and since the Interwebs couldn’t help me out, I’ll post it here for anyone else who might need it.

I was trying to import an Excel file that was basically a copy and paste from a different file.  So the file itself was pretty new, not like it’d been worked over a lot.  I tried to import it, however, and got the following error message:

GET DATA /TYPE=XLSX  /FILE=*****
/SHEET=name ‘RawData’
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
>Error.  Command name: GET DATA
>(2063) Error reading information for sheet.
>* Sheet Name: “RawData”
>This command not executed.
DATASET NAME DataSet1 WINDOW=FRONT.

The error, as I could figure out, was probably due to me having calculations lower down in my sheet.  I copied and pasted values into a brand new sheet, and that imported just fine.  If you’re having the same issue, try copy and pasting Values only into a new sheet and see if that helps.

The More You Know…..  😉

Advertisements