I think I already know the answer to this, but I need independent
verification to defend a decision I made.

If you are validating a drop-down list from another Excel file, that file
must be open, correct?

Also--and I'm a bit unclear on this--if multiple users open workbooks that
reference the same external file for drop-down lists, the lists will not be
populated, correct.

Thanks in advance for your advice!