Thread: GETPIVOTDATA Reference
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default GETPIVOTDATA Reference
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 he
http://www.mediafire.com/file/zb3nmywgtjz/01_23_09.xlsm
Reply With QuoteReply With Quote