GETPIVOTDATA Reference

[ScottS]

Hello All,

Is it possible to use a cell reference for the Data_Field argument of the
GETPIVOTDATA function? I keep getting the #REF! error when I try this.

Thanks in advance for any help on this.

 

[ryguy7272]

Of course you can reference cells! That function is a little tricky and it
takes some getting used to. Once you get acquainted with it though, you can
do some absolutely amazing things!! Check this out:
http://www.contextures.com/xlPivot06.html
http://www.mefeedia.com/tags/getpivotdata

HTH,
Ryan---

 

[ScottS]

Thanks for the help. I have used references for some time now but have run
into a problem with this particular spreadsheet. I have cell references in
place for the other references that work just fine, but the the Data_Field
argument will not work when I replace the text entry in the function with a
cell reference.

I'll keep working on it.

 

[Herbert Seidenberg]

Excel 2007
For Data Field in GetPivotData() Use TEXT(MyRef,"@")
Other text operations like LEFT(MyRef,5) work too.
Other arguments in GetPivotData() don't have that problem.
See my formulas in Table4 here:
http://www.mediafire.com/file/zb3nmywgtjz/01_23_09.xlsm

 

[ScottS]

Herbert

Sorry for the extended delay in a reply -- thanks for this excellent
solution! I was running into problems using a reference for the data field
in my getpivotdata formula and using the TEXT function took care of it.