GETPIVOTDATA under Excel 2000

[steveski]

Can anyone give me advice on the differences between how th
“GETPIVOTDATA” command works differently in EXCEL 2002 vs. Excel 2000
I created a file in Excel 2002, but I must install it on a compute
using Excel 2000, and the Excel 2002 GETPIVOTDATA syntax does not wor
under Excel 2000.

Thanks

 

[Debra Dalgleish]

There's information in the following MSKB article:

HOW TO: Use the GetPivotData Worksheet Function in Excel 2000
http://support.microsoft.com/default.aspx?id=211949

and there are examples in Excel's Help files.

 

[steveski]

Can you tell me when Excel first started including PivotCharts
Apparently they were not in Excel ’97. How about Excel 2000? Thanks

 

[Debra Dalgleish]

PivotCharts were introduced in Excel 2000.
In Excel 97, you can open a file that contains a PivotChart, and it will
appear as a normal chart.