Getpivotdata "N/A" error

S

stevec

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?
 
D

Debra Dalgleish

You can enclose two word items in single quotes. For example:

=GETPIVOTDATA(Pivot!B5,"Ontario 'Pen Sets'")
 
Top