Select a cell in a Pivot table

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

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
 
Hi,

Click in the pivot table and choose PivotTable Tools, Options tab, open the
Options drop down in the PivotTable group on the far left and turn off the
Generate GetPivotData.

If this helps please click the Yes button.
 
Back
Top