In the help file it says you can link a pop up menu (data/validation) from a
list in another workbook if you create a name in your worksheet and you link
the reference to the list in the second workbook.

In real life that doesn't happen, you get an error saying you can't feed
the pop up menus (data validation) from references in another workbook even
though you do it in an indirect way as suggested by the help file.

Any thoughts?

Regards