I am using a pivot table set up by someone else about 5 years ago. One of the fields is 'Staff Type' and data validation forces the user to select from "A" "G" or "V". However, on the pivot table, the Staff Type Field displays "Academic" "General" or "Visitor" in the sub headings. I can easily replace the data to get whichever I ultimately want displayed, but I want to know why this is happening? I can't find any field settings that tell the pivot table to display alternative text to what is in the table. Any clues?