Data_field parameter in getpivotdtata as a cell reference.
 

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

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")


Tomas wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html