Select a cell in a Pivot table

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
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top