Export tables from SPSS 16 output to Excel?

[Iwona]

I'm unable to export (large) tables in SPSS output document to Excel. I've
already installed the patch (SPSS 16. 02), but only a part of the table
goes through (I get an Excel error message saying that the file is corrupt
and can't be restored). Please help! Thanks!

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Arthur Burke]

You say that your SPSS tables are large.  Excel handles a maximum of 256
columns.  Are your SPSS tables larger than that?

Art

-----Original Message-----
From: Iwona [mailto:[hidden email]]
Sent: Tuesday, March 03, 2009 5:50 PM
To: [hidden email]
Subject: Export tables from SPSS 16 output to Excel?

I'm unable to export (large) tables in SPSS output document to Excel.
I've already installed the patch (SPSS 16. 02), but only a part of the
table goes through (I get an Excel error message saying that the file is
corrupt and can't be restored). Please help! Thanks!

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list
of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[SPSS Support]

Iwona,
   There were some known problems in SPSS 16 with regard to exporting large tables or many tables to Excel files. I have pasted a related resolution below my signature. There were some fixes for the problem implemented in SPSS 17, but the problems are expected to be fully resolved in SPSS 18.

David Matheson
SPSS Statistical Support

******************
Resolution number: 77423  Created on: May 13 2008  Last Reviewed on: Dec 12 2008

Problem Subject:  Excel file appears corrupted right after export from SPSS Output Viewer

Problem Description:  User is exporting a large number of tables and her Excel file appears corrupted immediately after it is created from SPSS Output Viewer. Excel reports that it attempted to repair the error but was unable to do so.

The log file of the Excel error is as follow -

"Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\User\Desktop\Example.xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

What is the problem?

Resolution Subject: This problem has been reported to SPSS Development - Workaround Available

Resolution Description:
Please see the workaround described below. We apologize for any inconvenience this has caused.

These suggestions may not work in all cases, but they should help alleviate this problem for most cases.

- Exporting a smaller number of tables
- Export to a different format
- Try to cut and paste the table(s)


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Arthur Burke
Sent: Wednesday, March 04, 2009 4:02 PM
To: [hidden email]
Subject: Re: Export tables from SPSS 16 output to Excel?

You say that your SPSS tables are large.  Excel handles a maximum of 256
columns.  Are your SPSS tables larger than that?

Art

-----Original Message-----
From: Iwona [mailto:[hidden email]]
Sent: Tuesday, March 03, 2009 5:50 PM
To: [hidden email]
Subject: Export tables from SPSS 16 output to Excel?

I'm unable to export (large) tables in SPSS output document to Excel.
I've already installed the patch (SPSS 16. 02), but only a part of the
table goes through (I get an Excel error message saying that the file is
corrupt and can't be restored). Please help! Thanks!

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list
of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Iwona]

Art,
Thanks for your response. My tables are only 5 columns, but some 1000
rows. A friend has an earlier version of SPSS (version 13)which was able
to handle it with no problem. By the way, I'm using Excel 2003 on my
system, and your comment got me thinking that perhaps it could be Excel.
Anyway, I need all the help I can get. Thanks again,
-Iwona

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Iwona]

David,
Thank you for your help. It's what I've suspected, but it's good to know
that there are no immediate fixes to this problem. After installing the
SPSS 16.02 patch, I'm able to export tables in text format (couldn't do it
before). Many thanks!
-Iwona

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD