How to I exclude GETPIVOTDATA from formulas?

[lthomson]

How can I get rid of the GETPIVOTDATA from formulas? I want to create
formulas and be able to copy them with relative references (not absolute)

 

[Bernie Deitrick]

Type in the cell address, rather than clicking on the cell in the pivot table.

HTH,
Bernie
MS Excel MVP

 

[Debra Dalgleish]

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

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