GetPivotData Function Error

  • Thread starter Thread starter Sal Rosario
  • Start date Start date
S

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?
 
If your field name includes a space, enclose it with single quotes:

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