The GetPivotData function arguments are different in Excel 2000, and I
don't know of any way to automatically convert them from the Excel 2003
structure.

In Excel 2000, the formula isn't automatically created when you link to
a pivot table cell, so you'll probably have to rebuild them.

MK wrote:
I have a tough problem I really need solving.
For work I had to do a huge report with a lot of getpivotdata function from
a number of pivot tables. The platform i used was Excel 2003, which I use at
home.

However, I realised that at work they only have excel 2000, and it is the
only version that employees are allow to use.

When I opened up the file at work on Excel 2000, and although the numbers
are there, when the pivot data changes or gets refreshed, the data on the
reports with the Getpivotdata functions become errored. I heard that the
syntax for the function in Excel 2003 is different from Excel 2000.

I have been crying over this, and I am looking for a solution.
please help, I am very desparate, as the report took me over 3 weeks to
complete.

Thank you in advance

MK


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html