Thread: Getpivotdata - referncing a data_field resulting in "REF!
View Single Post
  #2   Report Post  
Peter
 
Posts: n/a
Default
Interestingly this works too

=GETPIVOTDATA(A1 & E3,$A$3,E1,I$4+1,"WeekDay",$G9) where cell E3 contanins
the
text : New Subscribers and A1 is a blank cell.



Reply With QuoteReply With Quote