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?