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

Debra Dalgleish has a short video he

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

On Aug 22, 11:17*pm, Gerardo
wrote:
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

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

Regards

"Pete_UK" wrote:

Debra Dalgleish has a short video he

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

On Aug 22, 11:17 pm, Gerardo
wrote:
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

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

On Mon, 25 Aug 2008 08:20:01 -0700, Gerardo
wrote:

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

Regards

"Pete_UK" wrote:

Debra Dalgleish has a short video he

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

On Aug 22, 11:17 pm, Gerardo
wrote:
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