There's a sample file here that you could adapt to your workbook:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0022 - Update Validation Selections'

irish2171 wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html