GETPIVOTDATA in Execl 2000

[gtg430i]

Hello,

I ve been struggling with this. I need to extract data from a pivot table using GETPIVOTDATA. Now I know that the syntax in excel 2000 differs from the newere versions of excel. However I tried it and can get it done.

Please Login or Register  to view this content.

I just attached a simple pivot table for a simple example, it would be great if you can simply show me how u write the formula to extract any data.

Thank You,

[Norie]

It would also be great if you told us what data you want to extract.

[gtg430i]

Ok sorry about that. Say I need to extract the sum of the Units produced by 2 operators, on machine 4 during shift one. The answer should be 13, but how can I write this formula in the excel cell.

This example will help me a lot on the big pivot table that I have.

Thank You,

[Teethless mama]

=GETPIVOTDATA("Units Produced",A3,"Number of Operators",2,"Machine Number",4,"Shift",1)

[gtg430i]

Thanx for the help, but this still doesnt help. It return an error saying the formula I typed contains errors. I believe this syntax does not apply in excel 2000.

Please let me know if you have any other suggestions.

Thank You,

[gtg430i]

Hello,

I am still waiting on the exact syntax to use Getpivotdata in Excel 2000. Please help, it would save me a lot of time.

Thank You,