Can this be done. I read some posts suggesting it could, but I get a REF
error. Here is my formula:

=GETPIVOTDATA(B20,BoardPivot!$A$3,"Shift",D20,"Yea r",Calculations!$B$15,"Month",Calculations!$B$1 4)

B20 is a cell containing:

=CONCATENATE("M ",A20," KPH")

and A20 is a three digit number.

"M 122 KPH" is an example. This is a calculated field. I am using Windows XP
and Office 2003.

It works when I enter the field name directly so it is almost certainly the
source of the error.