I don't get that message in Excel 2002. Something you could do :

Select *one* cell that contains the validation.
Goto DataValidation
Edit the source as needed.
OK out

With that cell still selected
Goto EditCopy
Select the other cells that use the same validation
Then, goto EditPaste SpecialValidationOK

If you used a range of cells as the source and used a dynamic named range
then all you would have to do is edit the range and the source would update
automatically.

--
Biff
Microsoft Excel MVP


"Jeff H." wrote in message
...
When I created the list in Data Validation, I just typed the names in the
source box with a comma between eash name. Did not created a range.

"Gord Dibben" wrote:

Where is the source for the DV list?

From a defined named range like =MyRange?

From a list on a sheet like =A1:A10?

A comma delimited list in the source dialog like joe,mary,pete,agnes?

Change or add to the contents of any of those to get a new list.


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 10:54:01 -0800, Jeff H. <Jeff

wrote:

Hi,
I am using Excel 2003 at work and I have a spreadsheet that contains
data
validation dropdown list. I need to edit my list to add co-workers. When
I
goto Data Validation, I receive a dialog box message saying (Selected
cells
already contain data validation, do you want to erase data and
continue?). I
do not want to erase the current data, I just want to add to it. When I
am
using Excel 2000 at home I can edit the data without receiving this
message.
Is there a step with Excel 2003 that is different or a setting I need to
change to edit my data?