Cross-tabs notes disappearing in export to excel, SPSS19

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Cross-tabs notes disappearing in export to excel, SPSS19

Alex Huang
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Cross-tabs notes disappearing in export to excel, SPSS19

Alex Huang
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Cross-tabs notes disappearing in export to excel, SPSS19

Bruce Weaver
Administrator
And thank you, Alex, for posting the solution in such detail.  Far too often, people who figure out the answer to their own question either say nothing at all, or post something like, "Never mind...I figured it out!"  Your post is a great example of what people ought to do when they figure out the answer to a question they posted.  Cheers!


Alex Huang wrote
Dear List,

I have figured out the solution to this problem myself and would like to share this with you.

The behavior can be changed, no matter SPSS 19 or later version, by checking the option to include footnotes and captions during the export to Excel. It is exactly:

Click File - Export - Change Options - check the option "Include footnotes and captions" - OK.

ref: http://www-01.ibm.com/support/docview.wss?uid=swg1PM42210

Regardless, I thank everyone who may have been thinking about the solution for me.  

Thanks,
Alex
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING: 
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).