Data Validation in another Workbook - HELP!

[Rich58]

I've tried following the MS Online documentation but no luck.

I want to setup data validation with the validation data residing in a
different workbook. Any help will be appreciated.

 

[Dave Peterson]

Maybe Debra Dalgleish's notes will help:
http://www.contextures.com/xlDataVal05.html

 

[Biff]

It requires the other workbook be open to work properly.

See this:

http://contextures.com/xlDataVal05.html

Biff