GetPivotData and cell references

M

MFINE

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
 
D

Debra Dalgleish

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

=GETPIVOTDATA(G3&"",$B$3,"Year",F4)
 
M

MFINE

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA #REF! error XL2003/2010 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Getpivotdata - able to reference to another cell all parameters but not the datafield 6
How to translate a getpivotdata formula into a cell reference 0
Excel 2007 GetPivotData Function 2
GETPIVOTDATA Reference 4
GETPIVOTDATA function 1

Top