Receiving 'Error 2054: file is not in a recognized Excel file format' when trying to import an *.xls file into IBM SPSS Statistics

Technote (troubleshooting)


Problem(Abstract)

You work with IBM SPSS Statistics and receive 'Error 2054: file is not in a recognized Excel file format' when you try to import an *.xls file via file - Open - Data menu or via syntax command "GET DATA /TYPE=XLS".

Resolving the problem

This error occurs most likely if on this machine several SPSS Statistics versions has been installed in parallel. Please uninstall all Statistics applications from this machine via Control Panel - Uninstall a program.


After uninstallation cleanup the Windows Registry from SPSS Statistics folders and keys to have a fresh environment.

Please open the windows registry by writing "regedit" into the Windows Run... dialog and go into the following path:
HKEY_CURRENT_USER\Software\JavaSoft\Prefs\com\ibm\/S/P/S/S
First do a right mouse click on the /S/P/S/S folder and select "Export" and select a path where you want to temporary save this folder.
Then delete this folder by doing again a right mouse click on this folder and select "Delete".

When this cleanup is done, please re-install SPSS Statistics again and you will be able to open XLS files via the menu or command syntax.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

22.0, Not Applicable

Operating system(s):

Windows

Reference #:

1654061

Modified date:

2013-10-24

Translate my page

Machine Translation

Content navigation