Excel - Pivot Table Not Behaving as Expected

Good morning.  Sample of data going into pivot table:

Couny Year Type
Adams 1980 NON
Adams 1980 NON
Adams 1995 TYP
Athens 2001 TYP

Row Lable=3DCounty and Sum Value =3D County Column =3D Year
End result is a crosstab where row=3Dcounty, column =3D year and the values=
represent the number of times the county was present for each year.  All w=
as working fine.

I appended some new records to the data source, expanded the range and hit =
refresh.  I added a couple more lines for Adams and Athens counties.  Excel=
seems to think the values for county in the new records are some how diffe=
rent from the old.  They are not.  I have cleared the formats.  Cut and paste=
d to a new worksheet and nothing, I still end up with 2 entries for each co=
unty.  To the naked eye, Adams looks like Adams, but the computer must some=
how be seeing something different.  And ideas at all?

Mike

es represent the number of times the county was present for each year.  All=
was working fine.
t refresh.  I added a couple more lines for Adams and Athens counties.  Exc=
el seems to think the values for county in the new records are some how dif=
ferent from the old.  They are not.  I have cleared the formats.  Cut and pas=
ted to a new worksheet and nothing, I still end up with 2 entries for each =
county.  To the naked eye, Adams looks like Adams, but the computer must so=
mehow be seeing something different.  And ideas at all?

I got it.  I used the trim function and it solved the mystery.  Apparently,=
the spaces in the appended records was causing the problem.