Data_field parameter in getpivotdtata as a cell reference.

[Tomas]

Please can someone help me?

I would like to use parameter data_field as cell reference in getpivotdata
function?
Is it possible and if yes so plesae how?

I tried it several times but result is still #REF!.

Example: =GETPIVOTDATA(B4;$A$3;"Partner";"ABC")

There goes about the B4 parameter because if I rewrite value from cell B4 as
a text then it returns right data.

Thanks in advance

 

[Debra Dalgleish]

If you append an empty string at either end of the cell reference, the
formula should work, e.g.:

=GETPIVOTDATA(""&B4;$A$3;"Partner";"ABC")
or
=GETPIVOTDATA(B4&"";$A$3;"Partner";"ABC")