I.e. syntax for getpivotdata is
GETPIVOTDATA(data_field,pivot_table,field1,item1,f ield2,item2,...)

I'd like the data_field to be a reference, but I get #REF errors when I try
this.

ex: GETPIVOTDATA ($B$1,pivot_table,field1,item1,field2,item2,...)

any ideas?