Can I make the data_field in the getpivotdata formula a cellrefere

[Henk]

I.e. syntax for getpivotdata is
GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,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?

 

[Debra Dalgleish]

Add an empty string to the data field reference, e.g.:

=GETPIVOTDATA(J5&"",$A$6,"Region","Central")