Pivot Table Formats in Excel 97

[Raul]

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]

The following code will display the data fields horizontally:

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