I had 2 columns in the row data area of my pivot table. The columns
contained names as Last name and First name. The Pivot table was sorting a
name May to the top. I think Excel 2007 was interpreting the data and
sorting it as a month. I had to combine the last name, first name MI
together so it would sort properly.

Would you consider this a Bug?