Hi

i am now using Excel 2007

I create a pivot table and outside a pivot i want to compare some of the
numbers within the Pivot. When I enter =A5 for instance in another cell the
formula becomes GETPIVOTDATA("PL"........

How do i change this so it just references the cell address (so I copy the
fomula across lots of other cells. There was effectively a toggle button in
old excel but I cannot find it now.

Thanks
--
Kevin