Can you post a sample workbook?

What do you mean by "data validation list"? Do you have comboboxes, listboxes, etc.? Are they form controls, ActiveX controls?

You need to provide more information before the question can be answered.