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

Rich58 wrote:

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