Problem with getpivotdata function

G

Guest

I posted this to the Function area but didn't get any response so I thought I
would try here. If you can help, I'd greatly appreciate it.

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
 
D

Debra Dalgleish

Is it always the same items that cause the problem?
Are there extra space characters in the pivot table or in the
GetPivotData formula?
I posted this to the Function area but didn't get any response so I thought I
would try here. If you can help, I'd greatly appreciate it.

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