refer to http://www.contextures.com/xlPivot06.html

to use the GenerateGetpivotdata button to stop Excel generating
Getpivotdata functions and substitute conventional cell references.
Then just reference the cell you want.


--
BardofAvon
------------------------------------------------------------------------
BardofAvon's Profile: http://www.excelforum.com/member.php...o&userid=16075
View this thread: http://www.excelforum.com/showthread...hreadid=275069