| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get GETPIVOTDATA to work?
I'm using the GETPIVOTDATA function in one sheet looking at a Pivot Table in
another sheet in the same workbook. My Pivot Table is a Named Range "MMA_TAC". Oct-06 is the data Field (Formatted as text), RC and Include Flag are rows, and Loc is a Column. All I can get is #REF! =GETPIVOTDATA("Oct-06",MMA_TAC,"RC","1","Include Flag","Y","Loc","04") I'm using Excel 2002 SP3 Thanks -- Alan L |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need flexible tool to work with flat files - Excel No Good | Excel Discussion (Misc queries) | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| Work Rota - Do I need a formula? | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Threaded Mode
