Of course you can reference cells! That function is a little tricky and it
takes some getting used to. Once you get acquainted with it though, you can
do some absolutely amazing things!! Check this out:
http://www.contextures.com/xlPivot06.html
http://www.mefeedia.com/tags/getpivotdata

HTH,
Ryan---

--
RyGuy


"ScottS" wrote:

Hello All,

Is it possible to use a cell reference for the Data_Field argument of the
GETPIVOTDATA function? I keep getting the #REF! error when I try this.

Thanks in advance for any help on this.

--
Scott S