GETPIVOTDATA data_field help

G

Guest

When I enter a reference to a cell, eg A2, as the value for the data_field item in the GETPIVOTDATA I get a #REF error. However, when I instead type the value of A2, eg 2003, manually into the GETPIVOTDATA formula, it works. Can anyone please help--I want this formula to vary based on what is in A2.

Cheers
 
B

BrianB

This function is so variable in action, and difficult to handle, that
have given it up in favour of VLOOKUP. In fact, having no problem i
use with pivot tables
 
D

Debra Dalgleish

Try copying the headings from the pivot table, and pasting them into the
cells that you want to use as references.
 

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

Getpivotdata - able to reference to another cell all parameters but not the datafield 6
GetPivotData and cell references 2
GETPIVOTDATA function 1
Data_field parameter in getpivotdtata as a cell reference. 1
GETPIVOTDATA #REF! error XL2003/2010 1
GETPIVOTDATA Reference 4
Getpivotdata - referncing a data_field resulting in "REF! 2
Can I make the data_field in the getpivotdata formula a cellrefere 1

Top