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.
 
Back
Top