How to refresh the list

B

Blue Fish

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!
 
G

Gord Dibben

Looks OK to me.

On "Class" sheet add some choices below TestEE or delete or add anywhere in the
list.

You will see the changes in the DV lists on Sheet1.

What do you think is "not success"?


Gord
 
B

Blue Fish

You can see that I have change the sheet "Class" Cell A1 is "Test AAA"
but the "sheet1" Cell A8 still display the old value. How can I make the
cell A8 to reflect as "Test AAA"?

Thanks!
 
Top