Only when it is open,

INDIRECT can be used with referencing another open workbook, but not a
closed one.

There are alternatives for INDIRECT on a closed workbook, but if they
will work in a validation list I don't know.
(Posted that 2 days ago) see
http://groups-beta.google.com/group/...21139c2e690340

DM Unseen