Drop Down List

G

Guest

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.
 
B

Biff

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
 
G

Guest

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 here:
open both workbooks
copy the list
return to dest. sheet
insert special
select link



"bobb" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a drop-down list from a range of cells 2
Formatted cell column in drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
Data Validation - reference to another workbook 2
Displaying drop down list arrows 2
customize drop-down box 1
extend the range of cells for a drop down list 8
Created invoices in Excel - not working in Drive 1

Top