Manually type a simple link formula
which points to the top left cell within the pivot, eg: =B5
Then you can copy it across/down as required

Debra explains how to switch the feature off he
http://www.contextures.com/xlPivot06.html
Excel -- Pivot Tables -- GetPivotData
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Mervyn Thomas" wrote:
I have some data in a pivot table which I want to use in a calculation but
when I try to key off a cell in the table the new cell is a calculation
....GetPivotTable....... and it is impossible to drag this cell down to
other cells that correspond to other cells in the pivot table.
Am I explaining myself??
Or: How do I refer to the contents of a cell in a pivot table?