Dont think that is possible
1 workaround
simply copy the list to ur sheet
2 workaround
if u ned a link to the other workbook cus list is changed he
open both workbooks
copy the list
return to dest. sheet
insert special
select link



"bobb" skrev:

I am trying to create a drop down list and the list is in another workbook. I
followed the help instructions to create the list referencing the cells in
the other workbook. That works fine. But when I try to add a drop down from
data/validation and I type in =ListName it tells me it can't use a list from
another worksheet or workbook. The help clearly says you can.