Linking to pivot table values

  


If you find yourself getting error messages when linking to pivot
table values, it may be because the formula is not seeing the cell as
a text, so you may get a "REF#" error.  In this case, you can replace
the cell - e.g. A1 with T(A1).  The function T() returns the text
referred to by the cell. 
So for example, if you get an error message with the formula 


=GETPIVOTDATA($A3,"PivotTable","MONTH",B$2,"YEAR",$A$1) 


where $A3 contains the variable, B$2 contains the month and $A$1
contains the year, 
You would replace it with 


=GETPIVOTDATA(T($A3),"PivotTable","MONTH",B$2,"YEAR",$A$1) 


which will put in the text for A3 so the formula can calculate.