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)