editing a data validation list

[dslocum]

I have Excel 2007 and have Data Validation lists that need to be edited
The list is called EMPLOYEE and lists all of the possible employee
that might be assigned to perform a task. We have hired new employee
and need to modify the list. I have added the 2 new employees to th
list and sorted the list alphabetically. When I use the list in a Dat
Validation setting the 2 new employees are in the list but the last
employees on the list are gone.

I tried going to Formulas, Defined Names, Define Name and redefinin
the range of data that makes up the list called EMPLOYEE. However
when I hit OK I get the following error, The name entered alread
exists. Enter a unique name.

Is there a way to edit a defined list or am I forced to create a ne
list with a new name?

Thank you as always...

denn

 

[Elkar]

In the FORMULAS section, next to the "Define Name" button, there should be
another button called "Name Manager". Use this, select the name you want to
change, then click "Edit".

NOTE: You could also just hit CTRL-F3 to bring up the Name Manager.

HTH
Elkar

 

[dslocum]

Elkar

I never thought to click the Name Manager icon. For whatever reason
always thought that image was just a Title Image announcing that th
three buttons to the right were for managing names.

Thank you as always; it worked perfectly.

denn