Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excle Pivot Table Appends a '2' to the field data items

Jul 12, 2005 1:16AM PDT

My pivot tables work great but sometimes when I update them the field data entries are appended with a '2'

For instance a list of locations might contain the entry "Houston2" but the original data for that was just "Houston"

After remaking the pivot table and putting the exact same setup for it, it work fine again....for a while..

Why is this happening to me !? HELP!!

Discussion is locked