C
conniemm
I'm using Excel 2000 and have created a formula using the getpivotdata
function. For most of the values being looked up, values are returned. There
are a few instances where the data being looked up is returning a value of
"#N/A". I can't understand why this is happening because there is valid data
in the pivot table. If I change the name of the customer field in the pivot
table and in the getpivotdata formula, the data is returned.
What's going on here? I've tried adding and taking out quotation marks. It
doesn't seem to be working consistently.
Here's the formula:
=GETPIVOTDATA('[Data.xls]Data'!$D$19," 'ABC' 'DEF' 'Logicom' 'Units'")
Thanks,
Connie
function. For most of the values being looked up, values are returned. There
are a few instances where the data being looked up is returning a value of
"#N/A". I can't understand why this is happening because there is valid data
in the pivot table. If I change the name of the customer field in the pivot
table and in the getpivotdata formula, the data is returned.
What's going on here? I've tried adding and taking out quotation marks. It
doesn't seem to be working consistently.
Here's the formula:
=GETPIVOTDATA('[Data.xls]Data'!$D$19," 'ABC' 'DEF' 'Logicom' 'Units'")
Thanks,
Connie