Thank you all for giving me those suggestions.

For one, I have looked for a software out there on the net on this, but so
far unsuccessful.

I haven't yet attempted to save as a MS Excel 2000 sheet from my excel 2003
at home, and I will definately give this a try.

I don't mind paying for a software that converts syntaxes, as I have
permission to bill the company (to a certain amount) for this! Please, it
anyone has any idea, let me know!!!

Thank you again in advance.

MK



"Debra Dalgleish" wrote:

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