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?

The following code will display the data fields horizontally:

With ActiveSheet.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