GETPIVOTDATA data_field help

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
Can I make the data_field in the getpivotdata formula a cellrefere 1
Getpivotdata - referncing a data_field resulting in "REF! 2

Back
Top