Pop up menus in cells fed by lists in another workbook

[Gerardo]

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

 

[Pete_UK]

Debra Dalgleish has a short video here:

http://www.contextures.com/xlVideos07.html#DataVal01

which shows how to set up Data Validation from a list in another
worksheet.

Hope this helps.

Pete

 

[Gerardo]

Thank you, that does work but the help file says you can use a second
workbook for source and that is not working.

Regards

 

[Gord Dibben]

See this alternate site.

http://www.contextures.com/xlDataVal05.html

Note: the source workbook must be open as well as the target workbook.


Gord Dibben MS Excel MVP