Very quick q: a space causing a problem in GETPIVOTDATA

[linsalad]

Hey all,

I'm using GETPIVOTDATA in Excel 2000 to pull data from a pivot table.
It was going well, until I hit the following snag.

Picture this pivot table data, with the table being in the range of
A8:B25.

Code:
--------------------

page tab: United States
2002 2003
Name March April March April
Joe 6 9 123 1234
Mike 7 12 234 2344

--------------------

So doing a GETPIVOTDATA(A8:B25,United States Joe March) will give me a
6. This works fine.

However, when "Joe" changes to "Joe Blow" (notice the space), the
equation changes to this:
GETPIVOTDATA(A825,United States Joe Blow March)

...and I get 0.

Does that make ANY sense to anyone here? Why the heck can it understand
United (space) States, but not Joe (space) Blow? Is there a way to
force it to treat Joe Blow as one item...i.e. an extra ', ", or /" or
something?

Thanks!!
Dave

 

[linsalad]

Interestingly enough...I just tried the same basic formula (Joe Blow)
but on a different sheet... and THIS time it worked.

So I reformatted all the data to numbers, reformatted all the labels to
general...and it still won't work!

So I remade the entire pivot table, and then re-referenced all my
cells...and still no good!

Any idea why the formula works when it references "Joe Blow"'s data on
one sheet, but not the other?

 

[linsalad]

I figured out the problem: "Blow" occurs later in the pivot table a
well.

I.e.:

Joe Blow 232
Blow 123


Any idea how I can get around this problem (i.e. by forcing excel t
recognize it as "Joe Blow" and not "Joe" and "Blow")?

Thanks!
Dav