Re: Pivot Table Formats in Excel 97

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 02/24/04 

Date: Mon, 23 Feb 2004 22:40:04 -0500

The following code will display the data fields horizontally:

   With Active***.PivotTables(1).PivotFields("Data")
     .Orientation = xlColumnField
     .Position = 1
   End With

Raul wrote:
> I have a script that creates a pivot table report in
> Excel 2002 that uses the PivotCaches.add method and a
> format of xlReport2. The script works fine in Excel
> 2002, but does not work in Excel 97. Unfortunately I
> need to also create the same report in Office 97.
>
> I changed the script for Excel 97 to use the
> PivotTableWizard method which creates the pivot table but
> I can't get the pivot table report to display each data
> field in a separate column.
>
> Does anyone know how to format an Excel 97 pivot table
> report so that each of the data fields are in their own
> column? 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html