Problem with getpivotdata function

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Click to expand...
 
Back
Top