GetPivotData Function Error

[Sal Rosario]

We keep getting either the #N/A or #REF errors when using the GetPivotData
function. I created a range name called MyPivotTable for my pivot table and
I am trying to reference the intersection between a Territory and a Product.
My function reads like:
=GetPivotData(MyPivotTable,"US Matress")

Any suggestions as to the typical pitfalls when using this function?

 

[Debra Dalgleish]

If your field name includes a space, enclose it with single quotes:

=GetPivotData(MyPivotTable,"'US Matress'")