equations referring to data in a pivot table

H

HJ

I am running Excel 2002 on Windows XP. I am trying to write an equation that
refers to data in a pivot table. I'm getting weird "GETPIVOTDATA" equations
instead of a simple cell reference like I used to in Excel 95. Is there a
way to get a simple cell reference??
 
F

Frank Kabel

Hi
one way:
enter the cell reference manually instead of clicking on the cell with your
mouse
 
M

Mac

HJ:

The GetPivotData function is actually useful because the function will point
to the same data element in the pivot table, even if you pivot the data.
Embed the function into your formula instead of the raw cell reference.

Otherwise, follow Frank's advice and build the formula manually without
pointing to the data.

=Mac=
 
Top