Referring to external workbook in Data Validation

A

aposatsk

I have 2 workbooks. In one (1), i want to use Data Validation to creat
a drop down menu. The other (2) workbook has a range of data. In (1),
defined a range so that it uses the data in (2). I named it book4, an
it refers to: =[Book4.xls]Sheet1!$A$1:$B$4 . However, when i try t
enter "=book4" into Source in Data validation i get the error: You ma
not use references to other workbooks or worksheets in Data Validatio
Criteria".

But i clearly read that this is possible
 
A

aposatsk

I did this to fix the problem. Please tell me if this method is correc
and fool-proof.

Book 1 is where my validation is. Book 2 is where my data is. In boo
2, i highlighted the data and defined it as 'report'. In Book 1, i mad
another Name (Define) which goes to Book2 and gets 'report'; i name thi
"City". Then in data validation, i can enter City and it works
 

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

How do i get Data Validation to accept another workbook? 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
copying data validation to another workbook 3
Data Validation - can you use another workbook? 4
Data Validation in another sheet 1
Using Data Validation with a vlookup formula 3
Drop down Lists from a different workbook 1
create drop down list from different workbook 2

Top