GetPivotData and cell references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am trying to build a GetPivotData formula that uses cell references for
all the fields in the function. i have not been successful in substituting a
cell reference for the data_field - get a #REF! result. Using Excel/Office
2003.

Thanks for any suggestions

Marc
 
Concatenate an empty string to the data field's cell reference, e.g.:

=GETPIVOTDATA(G3&"",$B$3,"Year",F4)
 
Thanks Debra, this did it.

Marc

Debra Dalgleish said:
Concatenate an empty string to the data field's cell reference, e.g.:

=GETPIVOTDATA(G3&"",$B$3,"Year",F4)
Click to expand...
 
Back
Top