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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 23 Oct 2007 00:48 GMT

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,

Reply to this Message

Dave Peterson - 23 Oct 2007 13:44 GMT

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.

> Hi,
>
[quoted text clipped - 6 lines]
>
> Cheers,

Signature

Dave Peterson

Reply to this Message