How to I exclude GETPIVOTDATA from formulas?

G

Guest

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)
 
B

Bernie Deitrick

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum of getpivotdata() 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
GETPIVOTDATA from OLAP cube - grouped field 0
2007 Excel - GETPIVOTDATA 2
Pivot Table GETPIVOTDATA 2
GetpivotData returns a #REF! error 2
Copy GetPivotData Outside Report 3
Worksheet relative reference 3

Top