I don't think you can use GETPIVOTDATA to extract data from fields that
aren't currently visible. The Excel 2003 Help says: "If the arguments
do not describe a visible field, or if they include a page field that
is not displayed, GETPIVOTDATA returns #REF!."

http://office.microsoft.com/en-us/as...091071033.aspx

-Ryan

RonB wrote:
Is there a way to retrieve data from a PivotTable if the data isn't currently
visible? I can use GetPivotData, but when the table fileds are re-arranged,
the GetPivotData formula fails because the fields aren't currently visible.

Any way around this?