Visit Debra Dalgleish's site:
http://www.contextures.com/xlDataVal05.html

But take note that the other workbook has to be open.

Dee wrote:

Id like to keep my validation data for drop downs in a seperate workbook so
that many users/worksheets can reference it. However- data validation doesnt
seem to let me reference named ranges in a seperate workbook- any advise out
there?
--
Dee

--

Dave Peterson