Hello:

I have define a name and use it as the data validation list. However,
the name source has been updated but I found that the original list that
has choose didn't reflect the new data unless I re-choose from the drop
down list again. Does any methods that I can refresh the list without
re-choose all the cell again?

Thanks a lot!