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?