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.

If the source for the list is in another file that file must be open. If
that's not something you want to do put the source in the same file.

Biff

"bobb" wrote in message
...
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.

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.

bobb

It can be done.

Try following the instructions found at Debra Dalgeish's site.

May be easier to follow.

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


Gord Dibben MS Excel MVP

On Sat, 14 Oct 2006 12:34:01 -0700, bobb wrote:

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.