We are using Excel 2003. My spreadsheet is using a data validation list. If I
change an item in a data validation source list, the worksheet still shows
previously selected items. How can this be updated without manually going
back and re-selecting the new source data?