Refer to seperate workbook for validation list for drop downs?

[Dee]

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?

 

[Dave Peterson]

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

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

 

[Peo Sjoblom]

http://www.contextures.com/xlDataVal05.html