V. 16.0.2 slow with Excel, or crashes Excel

[Ian Martin-2]

If I select a pivot table in the output window and Edit>copy, it
takes about 2 minutes to copy the table so that I can paste it into
excel.  It also takes very long to select the cells of a table in an
edit window to do a change such as increasing the number of decimals
displayed.

If I export the table to Excel, it takes slightly less time, but then
excel crashes when I try to do something like changing the typeface
or type size.

Any suggestions, or word on whether V. 17 has this fixed?  I don't
think V. 17 academic site license is yet available.

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
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

[Weeks, Kyle]

Ian,

This area is greatly improved in v17.

Regards.


Kyle Weeks, Ph.D.
Director of Product Strategy, SPSS Statistics
SPSS Inc.
[hidden email]
www.spss.com
SPSS Inc. helps organizations turn data into insight through predictive analytics.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ian Martin
Sent: Wednesday, October 22, 2008 2:41 PM
To: [hidden email]
Subject: V. 16.0.2 slow with Excel, or crashes Excel

If I select a pivot table in the output window and Edit>copy, it
takes about 2 minutes to copy the table so that I can paste it into
excel.  It also takes very long to select the cells of a table in an
edit window to do a change such as increasing the number of decimals
displayed.

If I export the table to Excel, it takes slightly less time, but then
excel crashes when I try to do something like changing the typeface
or type size.

Any suggestions, or word on whether V. 17 has this fixed?  I don't
think V. 17 academic site license is yet available.

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
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]

Ian,
As Kyle noted, operations in the SPSS interface are much faster in SPSS 17. There was a program defect filed in regard to Excel 2003 crashing when tables exported from SPSS 16 were modified in Excel. This defect is still being addressed in SPSS 17. I've pasted a Resolution below, including a workaround, from the support.spss.com web site.

David Matheson
SPSS Inc.
Email: [hidden email]
Tel: [phone] / Fax: [phone] <http://support.spss.com/>
****************

Resolution number: 76281  Created on: Mar 11 2008  Last Reviewed on: May 20 2008
Problem Subject:  Excel 2003 crashes when reading data exported from SPSS 16 output

Problem Description:  In SPSS 16, I exported an output document into Excel format. When I open the generated *.xls document in Excel 2003, I can modify the data in the file but I'm unable to save my modifications. Excel generates the following error message "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience"

Resolution Subject: Save the excel document into Excel 4.0 format

Resolution Description:
This defect has been submitted to SPSS Development. We apologize for your inconvenience. Currently we have the following workaround for this problem : in Excel, you can save the document into the Excel 4.0 format. Once the document is in this format, the modifications in the data file can be saved.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Weeks, Kyle
Sent: Wednesday, October 22, 2008 4:15 PM
To: [hidden email]
Subject: Re: V. 16.0.2 slow with Excel, or crashes Excel

Ian,

This area is greatly improved in v17.

Regards.


Kyle Weeks, Ph.D.
Director of Product Strategy, SPSS Statistics SPSS Inc.
[hidden email]
www.spss.com
SPSS Inc. helps organizations turn data into insight through predictive analytics.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ian Martin
Sent: Wednesday, October 22, 2008 2:41 PM
To: [hidden email]
Subject: V. 16.0.2 slow with Excel, or crashes Excel

If I select a pivot table in the output window and Edit>copy, it takes about 2 minutes to copy the table so that I can paste it into excel.  It also takes very long to select the cells of a table in an edit window to do a change such as increasing the number of decimals displayed.

If I export the table to Excel, it takes slightly less time, but then excel crashes when I try to do something like changing the typeface or type size.

Any suggestions, or word on whether V. 17 has this fixed?  I don't think V. 17 academic site license is yet available.

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

=====================
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