See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal05.html

Note this part...................

For data validation to work, the workbook which contains the list must be
open, in the same instance of Excel. You could create the list in a workbook
that is always open, but hidden, such as the Personal.xls workbook.



Gord Dibben MS Excel MVP

On Wed, 10 Mar 2010 22:24:01 -0800, mb_bajaj
wrote:

Hi Carim

I wanted to use the validation function while my list is in another
workbook. I followed the same procedure, but did not help me. I am not sure
where m I doing some thing wrong?

Thanks