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?
--
maryj

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.


maryj wrote:
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
Contextures
http://www.contextures.com/tiptech.html

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?

--
maryj


"Debra Dalgleish" wrote:

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.


maryj wrote:
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
Contextures
http://www.contextures.com/tiptech.html

In Excel 2000, it would be similar to this:

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

maryj wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Thank you Debra!
--
maryj


"Debra Dalgleish" wrote:

In Excel 2000, it would be similar to this:

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

maryj wrote:
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
Contextures
http://www.contextures.com/tiptech.html