Date: Tue, 8 Oct 2002 06:34:02 -0700
Reply-To: Jean Hanson <jh87111@yahoo.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Jean Hanson <jh87111@yahoo.com>
Subject: Re: Pasting acctive pivot table into excel?
In-Reply-To: <3D096954057CD41185BE00508B5B01FE01D4FD09@MARS>
Content-Type: text/plain; charset=us-ascii
Dear Jim,
Try copying the pivot table as an object and then using paste special into excel.
Jean Hanson
Jim Savage wrote:New to SPSS but want to share the pivot tables with others via excel . Any
help would be appreciated.
Online help seems to say that you can paste an operating pivot table from
the output viewer into excel,but all I get when I copy or copy object
from SPSS output into excel is a static text .
Im using SPSS base 11.5 and had great hopes that I could use the pivot
tables to send complicated tables to others without SPSS so they could
interact with the data. If this doesn't work is there another way.
Jim Savage
Marketing Research & Analytics
jsavage@planetfeedback.com
Voice: 513.618.6710
Mobile: 513.919.0060
---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com