Pivot Table Formats in Excel 97

From: Raul (raul_das_at_bkitech.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 13:05:19 -0800

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?

Relevant Pages

  • Re: Help PLEASE! Not sure what answer is: Match? Index? Other?
    ... begins "The weekly sales ...", is not part of the report, but is rather part ... By putting the raw data into an Excel list structure, and basing a pivot ... Excel Sales Forecasting for Dummies, Wiley, 2005 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: why>?
    ... pivot can help to form these. ... Excel is WORTHLESS I mean you dipshits are the ones that need to get ... A database junkie who doesn't understand anything except how to ... produce a standardized, scalable, and replicable report, even if the ...
    (microsoft.public.excel)
  • Re: OO4O and Pivot Table
    ... I have a report scheduled to run every week by JP1. ... copy the result into another Excel file. ... Can we spread the data over several worksheets, and build a pivot ... and will do a refresh everytime it is open. ...
    (microsoft.public.excel.programming)
  • Re: report showing who logged in/out of nt 4 server
    ... permission to the log file (in the logon script solution, ... able to write to the log file, ... report any time, and you can use Excel to analyze the report. ...
    (comp.os.ms-windows.nt.admin.security)
  • Re: start & finish dates - what happens to dates inbetween
    ... my boss really wants a bar chart so I need to export to excel. ... > name for what Excel calls a pivot table report. ... > it, I get a report that shows weeks as columns, resources as rows with their ...
    (microsoft.public.project)