getpivotdata

[geebee]

hi,

i have the following in a cell:
=GETPIVOTDATA(D14, pivot!$O$7)

D14 is a cell reference, the cell containing a value.

but i am getting a #REF! error in this GETPIVOTDATA field.

what should i do?

thanksin advance,
geebee

 

[Max]

Try wrapping a T() around the cell ref D14:
=GETPIVOTDATA(T(D14),pivot!$O$7)

 

[Roger Govier]

Hi

I don't think you are giving the correct arguments to the GetPivotData
function.
Take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html
and download the sample file