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