Hi Patricia

Personnally I prefer to export data to a single excel sheet. The script I use groups lines related to a single table, charts or IGRAPH and collapses them to a single line in the Excel sheet (using the Group and Outline feature of Excel). Clicking on the + (-) in the left margin displays (hides) the table.I find this method very convenient to go from one table to the next when I have hundreds of tables / charts. It is easier than having to locate the appropriate sheet.

Take a look, this might be useful to you.

The version that exports all Layers of a Pivot Table is version 4 (see file #5 of the Excel section of http://pages.infinit.net/rlevesqu/SampleScripts.htm#ImportExport ).

HTH

Raynald Levesque rlevesque@videotron.ca Visit my SPSS site: http://pages.infinit.net/rlevesqu/

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of Patricia OConnor Sent: May 28, 2004 4:42 PM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Spss 12 Layered Pivot to Separate Worksheets

We generate several pivot tables with 3 to 57 layers in SPSS-12.

We would like to be able to export these pivot tables to Excel 2000 through syntax or vb/macros. Ideally, we would like each layer to populate a separate worksheet/tab, using the layer value as the tab name.

The code we have found will only export/copy the current layer to Excel. This necessitates editing the pivot to get next layer and running the code again. We are trying to get this into a production type mode and eliminate as much human interaction as possible.

Thanks in advance Patricia