thank you, thank you, thank you!!!!! I have been trying for hours to clear out old names in my pivot table dropdown option. I have excel 2003 version and tried all the other tricks. The language you provided worked perfectly.