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

--
Regards
Roger Govier



"geebee" (noSPAMs) wrote in message
...
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