GETPIVOTDATA problem

[Don]

Let's say I have a pivot table where the three row labels
in cells A5, A6, and A7 are Huey, Dewey and Louie. The
two column labels in cells B4 and C4 are Day Job and Night
Job. The amounts summed refer to wages.

If I enter GETPIVOTDATA(A38,"Louie Night Job", the
result are the wages Louie earns at his night job. So
far, so good.

However, I get an #N/A if I should do the following: In
the underlying data I change the name from Louie to
Louis. I refresh the pivot table so that the row label
now reads Louis, not Louie. I also change the
GETPIVOTDATA function to GETPIVOTDATA(A38,"Louis Night
Job").

This is driving me crazy. Any ideas? Thanks for your
help.

 

[Debra Dalgleish]

If a label is multiple words, it should be enclosed in single quotes,
e.g. "Louis 'Night Job'"