GET PIVOT Data Absolute Reference

  • Thread starter Thread starter Herman Merman
  • Start date Start date
H

Herman Merman

Whenever I reference to a field in a pivot table I get th
"GETPIVOTDATA....." worksheet function. This would normally be OK bu
this is an Absolute reference and I can't figure out how to get it t
make it a relative reference.

The only way I can do it is by taking out the formula and manuall
entering the cell reference - ie "A1". Is there any way the GETPIVO
function can be turned off??

:confused
 

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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
GETPIVOTDATA from OLAP cube - grouped field 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
GETPIVOTDATA Question 3
reference another cell in getpivotdata function 4
GetPivotData refer to external cell 4
Referencing Data in a Pivot table. More Excel 2003 misery 1
Change GETPIVOTDATA cell reference to A1 style 1

Back
Top