| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a cell ref for the data_field arg in a GETPIVOTDATA formula
I can create the following formula to retrieve specific data from a pivot
table: =GETPIVOTDATA("NewCorrel",$A$3,"MC1","NG Nova C & NIT","Ten1",DATE(2005,2,1)) However, if i try to put the text "NewCorrel" in Cell E18 (for example) and then rewrite the formula as shown below, i get a #REF! error. I can replace any of the other arguments with references to cells that contain the proper values, but for some reason when I try to do that with the data_field arg, I get the error. =GETPIVOTDATA( E18 ,$A$3,"MC1","NG Nova C & NIT","Ten1",DATE(2005,2,1)) Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to translate a getpivotdata formula into a cell reference | Excel Discussion (Misc queries) | |||
| GetPivotData from OLAP Cube Cell Referencing Formula. | Excel Worksheet Functions | |||
| Can I make the data_field in the getpivotdata formula a cellrefere | Excel Worksheet Functions | |||
| Data_field parameter in getpivotdtata as a cell reference. | Excel Discussion (Misc queries) | |||
| Getpivotdata - referncing a data_field resulting in "REF! | Excel Worksheet Functions | |||
Linear Mode
