I have a pivot table in excel 2007 with 1 row label that contains approx 50 elements. One of the data elements in the raw data is "wood", but here is the strange part, when refreshing the pivot table, what shows up is "wood2". All the other elements are fine, just that one. Anyone may know where/how it picked up the 2 and added it to the description of the row label element? I've never seen this and from looking everywhere I can think of, does not yield a "wood2" in any of the pivot options. I created another pivot table exactly as the original and did not have an issue, "wood" is exactly as it is suppossed to be. I can use the copy, but I'm perplexed as to how the "2" showed up.
Any ideas/suggestions?
Thanks