Getpivotdata behaving flaky

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top