GETPIVOTDATA between XL 2K & 03

[Guest]

I have a client with Office 2000. He shares files with users that have Excel
2003. Is there a way that the GETPIVOTDATA function can be used successfully
in both versions?

 

[Debra Dalgleish]

The function's arguments are different in Excel 2003 and Excel 2000.

If you create the formulas in Excel 2003, and users open the files in
Excel 2000, the formulas will return an error if the pivot table is
refreshed or changed, or if they recalculate the formula.

If you create the formulas in Excel 2000, Excel 2003 should calculate
them correctly if the pivot table is refreshed. Layout changes may cause
errors.

 

[Guest]

Thank you Debra.

Next question - The Getpivotdata function in the Excel 2003 file is
=GETPIVOTDATA("Circuits Scrapped",$A$3,"Year",2006,"Month",2). All of the
examples I have seen using the this function in Excel 2000 only have
arguments for pivot table and one argument for a field name. Is it possible
in Excel 2000 to have the function look for more than 1 pivot table field?

 

[Debra Dalgleish]

In Excel 2000, it would be similar to this:

=GETPIVOTDATA($A$3,"'Circuits Scrapped' Year 2006 Month 2")

 

[Guest]

Thank you Debra!
--
maryj

In Excel 2000, it would be similar to this:

=GETPIVOTDATA($A$3,"'Circuits Scrapped' Year 2006 Month 2")