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?