Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

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!

Re: GETPIVOTDATA causing problems

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

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

Typo Correction...

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.