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

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

Post by Sm9ob » Wed, 24 Oct 2007 08:48:01


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,
 
 
 

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

Post by Dave Peter » Wed, 24 Oct 2007 21:44:47

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.



--

Dave Peterson