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

Try wrapping a T() around the cell ref D14:
=GETPIVOTDATA(T(D14),pivot!$O$7)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"geebee" wrote:
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

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