referencing cells in a pivot table - wierdness.

  • Thread starter Thread starter David
  • Start date Start date
D

David

In a column out of a pivot table -- when I try and add 2
cells together that are in a pivot table, the cells do not
show as "F1"+"F2" -- they show as adding the pivot table
range + the pivot table range?

why does this happen and how can I get it to be f1+f2????


thanks
 
You're probably seeing the GetPivotData function, which is created in
some versions of Excel when you reference a cell in a pivot table. You
can change this setting, or you can type an equal sign, and type the
cell reference, instead of clicking on the pivot table cell to reference it.

To change the setting, there are instructions here to add the Generate
GetPivotData button to your toolbar. Then, use the button to turn this
feature on or off:

http://www.contextures.com/xlPivot06.html
 
Back
Top