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