This might work.

I created a new worksheet with formulas that refered back to the sometimes
closed workbook:

in A1:A10

='C:\my documents\excel\[book1.xls]Sheet1'!A1
thru
='C:\my documents\excel\[book1.xls]Sheet1'!A10

Then I named that range (Insert|name|define). I called it myList. And then I
hid that worksheet.

Then I use data|validation for the cell I wanted and used:
Allow: List
source: =myList

It seemed to work ok.

karambos wrote:

I would like to have a drop down menu in a workbook that allows only
values form another workbook that may or may not be closed at the
time.

Is this possible and if so I'd be grateful for any hints, tips and
pointers in the right direction.

Thanks as always

--
karambos
------------------------------------------------------------------------
karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262
View this thread: http://www.excelforum.com/showthread...hreadid=398969

--

Dave Peterson