SPSS Statistics

 View Only

 Issues with Excel Export

Ratna Wynn's profile image
Ratna Wynn posted Wed July 23, 2025 05:05 PM

Hi - we have been using custom tables and exporting to Excel each table so the output file has a separate title per question. So often files have more than 25 or more tabs. We are getting an error every time we export which looks something like below. 

If you can't open screenshots the error says "We found a problem with the content in SPSSoutput.xlsx. Do you want to try and recover as much as we can? If you trust the source of this workbook click yes. 

The second error when you click yes says "Excel was able to open the file by repairing and removing the unreadable content. 

The file opens but it changes all the formatting. Is there a workaround or some setting that needs to be changes so we don't run into this issue. 

Any advice would be much appreciated. 

David Dwyer's profile image
David Dwyer

Hi @Ratna Wynn
What version and platform of IBM SPSS Statistics are you using when you encounter this problem?

There was a Known Issue DT130824 reported against IBM SPSS Statistics 28.0.1.1 related to using the SAVE TRANSLATE command syntax with /APPEND subcommand.  This issue was addressed by Interim Fix and then in code for IBM SPSS Statistics 29.0.0.0 and later.  Was this your issue?