Sounds strange. It has been a while since I worked with SPSS. What you could do is try to load the file with an R package.
Also Excel might not be the best way to keep the types of variables. Does SPSS offer options like SQLite or Parquet which might be better suited for the task (and also KNIME can read them).