Thread: Getpivotdata "N/A" error
View Single Post
  #1   Report Post  
stevec
 
Posts: n/a
Default Getpivotdata "N/A" error
Excel is returning a "N/A" error for either of these
=GETPIVOTDATA('Detail Pivot'!$A$7,"Parts HP M12 total Sales$")
=GETPIVOTDATA('Detail Pivot'!$A$7,"Parts HP"&"M12 total Sales$")

I feel that having a 2 word row heading is causing the problem. How can I
fix this?
Reply With QuoteReply With Quote