GETPIVOTDATA causing problems

Posted by Mark Jeanes on August 07, 2001 3:10 AM

HI,

Can anyone help?

When I use GETPIVOTDATA to retrieve data from a pivot table, the result returns an #n/a error for no apparent reason. The number that I use as the parameter in the formula appears as a label on the pivot table concerned, but the correspondong total does not appear and an#n/a only appears.

HELP!

Posted by Mark W. on August 07, 2001 7:59 AM

So, why did you select the "For error values, show"
PivotTable option?

Posted by Mark W. on August 07, 2001 8:24 AM

Typo Correction...