validation

[bayanbaru]

I created a drop down list using validation. I then
realized I made an error in one of the list and corrected
the list. However I noted that this was not automatically
changed at the data entry cell. How can I auto refresh
them?

 

[Debra Dalgleish]

After you've selected an item from the data validation list, it's no
longer connected to the list. So, if you change the third item in the
source list from "Red" to "Blue", none of the existing data on the
worksheet will change.

You could use Edit>Replace to change the previously entered data on the
worksheet.