How to refresh the list

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

 

[Gord Dibben]

Some lists change frequently, with items being added or removed. If the list is
the source for a Data Validation dropdown, use a dynamic formula to name the
range, and the dropdown list will be automatically updated.

For instructions, view this page:

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP

 

[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

 

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