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


"lthomson" <[email protected]> wrote in message
news:[email protected]...
> 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)

[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

lthomson wrote:
> 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)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html