Referencing a pivot table

[Mike]

When I reference a cell in a pivot table in a formula,
the reference is "GETPIVOT(....)", not the cell address,
ie"M6". The "GETPIVOT" cell address is absolute so it
cannot be dragged or copied. Any ideas on how to make
the address so it can be copied?

Thanx

 

[Debra Dalgleish]

You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

As an alternative, you can simply type an equal sign, and type the cell
reference, instead of clicking on the cell to reference it.