referencing cells in a pivot table - wierdness.

[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

 

[Debra Dalgleish]

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