| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GETPIVOTDATA using a reference for field name
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Change GETPIVOTDATA cell reference to A1 style | Excel Worksheet Functions | |||
| GETPIVOTDATA - return cell reference, not value | Excel Worksheet Functions | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| can you use a variable or cell reference in a getpivotdata formul. | Excel Worksheet Functions | |||
Threaded Mode
