How to I exclude GETPIVOTDATA from formulas?
 

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)

How to I exclude GETPIVOTDATA from formulas?
 

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

HTH,
Bernie
MS Excel MVP


"lthomson" wrote in message
...
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)

How to I exclude GETPIVOTDATA from formulas?
 

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