"Sune Fibaek" wrote:
Is there a way of cheating GETPIVOTDATA() into using a cell reference as the
data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've tried
with just about every function I can think to get the text from J8 used in
the formula instead of having to write the text.

The T function seems to work ok when I tested it lightly,
so we could try: =GETPIVOTDATA(T(J8);$A$7;"Rep";$J$9:$L$9).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---