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!

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

On Wed, 02 Apr 2008 11:08:51 +0800, Blue Fish wrote:

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!

Hello:

Thanks a lot for your information. I have try to test but not success.
May I know does any miss from my test file?

Thanks!

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

On Wed, 02 Apr 2008 11:57:46 +0800, Blue Fish wrote:

Hello:

Thanks a lot for your information. I have try to test but not success.
May I know does any miss from my test file?

Thanks!

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!


Gord Dibben wrote:
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