Can I make the data_field in the getpivotdata formula a cellrefere
 

I.e. syntax for getpivotdata is
GETPIVOTDATA(data_field,pivot_table,field1,item1,f ield2,item2,...)

I'd like the data_field to be a reference, but I get #REF errors when I try
this.

ex: GETPIVOTDATA ($B$1,pivot_table,field1,item1,field2,item2,...)

any ideas?

Add an empty string to the data field reference, e.g.:

=GETPIVOTDATA(J5&"",$A$6,"Region","Central")

Henk wrote:
I.e. syntax for getpivotdata is
GETPIVOTDATA(data_field,pivot_table,field1,item1,f ield2,item2,...)

I'd like the data_field to be a reference, but I get #REF errors when I try
this.

ex: GETPIVOTDATA ($B$1,pivot_table,field1,item1,field2,item2,...)

any ideas?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html