Thread: How do I get GETPIVOTDATA to work?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default How do I get GETPIVOTDATA to work?
Maybe "1" should be 1.

You could try linking to a pivot table cell, to see the GetPivotData
formula that's automatically created. Then, change the pivot table cell
reference to your named range.

Lindy1 wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote