pivot table label adding "2" to the end of a label name

J

John

Hi,

I have a pivot table and sometimes it adds a "2" to the end of a row lable ie.
"joes pizza" is displayed as "joes pizza2".
the sorce data certanly doesn't include the "2" and it seems like it is
trying to tell me some thing ;). It might be hapening after i do a "replace
command" in the source data (replace "sams pizza" with joes Pizza"). any one
experienced this?

Cheers,
 
D

Dave Peterson

The only time I've seen this is when I had multiple headers with the same name.

If I were you, I'd check once more--don't forget to check in hidden columns,
too.
 

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

Similar Threads

Label alignment of XY-plot, center is a bit off. Any ideas? 0
Pivot Table - Row Label Combination 0
Pivot Table Row Label Problem 0
Macro - add 2 spaces after the end of a sentence. 0
Pivot Table Not Behaving as Expected 1
Pivot Table Row Label has been changed and won't change back 0
Change Legend Entry label of "Total" to actual name of field. 1
Calculated column label in pivot table? 0

Top