Data/Validate/List

B

BobxxCalgary

I am attempting to use a drop down list which is located in a separate
workbook. I've gone through the directions several times by using the help
menu "Create a drop-down list from a range of cells" When I get to the last
step which is entering the source, I get a pop up message which says "You may
not use references to other worksheets or workbooks for Data Validation
criteria" This is confusing because it specifically shows how to use separate
notebooks. Help anyone!
 
T

T. Valko

You would have to use a defined name for the source *and* the source
workbook *must* be open for it to work. What this boils down to is it may
not be worth the trouble and you'd be better off just putting the source in
the workbook where it's needed.

See this:

http://contextures.com/xlDataVal05.html
 

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
Excel 2003 using a list from another workbook 1
Create a drop-down list from a range of cell 4
Data Validation List Names 2
Data Validation 1
Data Validation Restriction Referencing other Workbook 1
if condition with data validation list 5
drop-down list validation won't allow a different worksheet 4

Top