Drop-Down List does not display choices
 

I have created a drop-down list to display the choices from another workbook.
If both workbooks are open then the drop-down list displays the choices but
if the source workbook is not open then the drop-down list does not display
any choices.

It needs to be open

--
Regards,

Peo Sjoblom

(No private emails please)


"Bill Freeze" <Bill wrote in message
...
I have created a drop-down list to display the choices from another
workbook.
If both workbooks are open then the drop-down list displays the choices
but
if the source workbook is not open then the drop-down list does not
display
any choices.