I am having trouble with a pivot table. Two entries in my source data
display in the pivot table with the numeral 2 appended to the end. This
particular data is city names and one of the offending entries is for La
Crescenta, but the table insists on displaying it as La Crescenta2. I have
deleted the source and retyped the entry but after refreshing the 2 is still
present. I have entered other data into the cell and it tables correctly. I
have entered LaCrescenta (without the space) and the table displays La
Crescenta (with the space) but without the 2. I entered the name in lower
cases without the space and get it back capitalized with the space but
without the 2. The other entry is Hilton Head Island and it behave the same
way. I've searched for similar problems and only encountered one which
suggested rebuilding the entire spread sheet as a work around. Any other
solutions or ideas on why this happens?
--
BNS