software

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,quot;Shiftquot;,D20,quot;Yea rquot;,Calculations!$B$15,quot;Monthquot;,Calculations!$B$1 4)

B20 is a cell containing:

=CONCATENATE(quot;M quot;,A20,quot; KPHquot;)

and A20 is a three digit number.

quot;M 122 KPHquot; 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.

Have you tried

=GETPIVOTDATA(indirect(B20),BoardPivot!$A$3,quot;Shift quot;,D20,quot;Yearquot;,Calculations!$B$15,quot;Monthquot;,Calculatio ns!$B$14)quot;Rayo Kquot; gt; wrote in message
...
gt; Can this be done. I read some posts suggesting it could, but I get a REF
gt; error. Here is my formula:
gt;
gt; =GETPIVOTDATA(B20,BoardPivot!$A$3,quot;Shiftquot;,D20,quot;Yea rquot;,Calculations!$B$15,quot;Monthquot;,Calculations!$B$1 4)
gt;
gt; B20 is a cell containing:
gt;
gt; =CONCATENATE(quot;M quot;,A20,quot; KPHquot;)
gt;
gt; and A20 is a three digit number.
gt;
gt; quot;M 122 KPHquot; is an example. This is a calculated field. I am using Windows
gt; XP
gt; and Office 2003.
gt;
gt; It works when I enter the field name directly so it is almost certainly
gt; the
gt; source of the error.
Add an empty string to the B20 reference:=GETPIVOTDATA(B20amp;quot;quot;,BoardPivot!$A$3,quot;Shiftquot;,D20,quot; Yearquot;,Calculations!$B$15,quot;Monthquot;,Calculations!$B$1 4)

Rayo K wrote:
gt; Can this be done. I read some posts suggesting it could, but I get a REF
gt; error. Here is my formula:
gt;
gt; =GETPIVOTDATA(B20,BoardPivot!$A$3,quot;Shiftquot;,D20,quot;Yea rquot;,Calculations!$B$15,quot;Monthquot;,Calculations!$B$1 4)
gt;
gt; B20 is a cell containing:
gt;
gt; =CONCATENATE(quot;M quot;,A20,quot; KPHquot;)
gt;
gt; and A20 is a three digit number.
gt;
gt; quot;M 122 KPHquot; is an example. This is a calculated field. I am using Windows XP
gt; and Office 2003.
gt;
gt; It works when I enter the field name directly so it is almost certainly the
gt; source of the error.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks. It actually didn't work, but I decided that I wouldn't need the
references to change so I just typed them in.

quot;Debra Dalgleishquot; wrote:

gt; Add an empty string to the B20 reference:
gt;
gt;
gt; =GETPIVOTDATA(B20amp;quot;quot;,BoardPivot!$A$3,quot;Shiftquot;,D20,quot; Yearquot;,Calculations!$B$15,quot;Monthquot;,Calculations!$B$1 4)
gt;
gt; Rayo K wrote:
gt; gt; Can this be done. I read some posts suggesting it could, but I get a REF
gt; gt; error. Here is my formula:
gt; gt;
gt; gt; =GETPIVOTDATA(B20,BoardPivot!$A$3,quot;Shiftquot;,D20,quot;Yea rquot;,Calculations!$B$15,quot;Monthquot;,Calculations!$B$1 4)
gt; gt;
gt; gt; B20 is a cell containing:
gt; gt;
gt; gt; =CONCATENATE(quot;M quot;,A20,quot; KPHquot;)
gt; gt;
gt; gt; and A20 is a three digit number.
gt; gt;
gt; gt; quot;M 122 KPHquot; is an example. This is a calculated field. I am using Windows XP
gt; gt; and Office 2003.
gt; gt;
gt; gt; It works when I enter the field name directly so it is almost certainly the
gt; gt; source of the error.
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;