Hi. I created a dropdown list in one workbook (Workbook 1) and the data
source is found in another workbook (Workbook 2). How do I make sure that
even if Workbook 2 is not open, the dropdown lists in Workbook 1 will still
display the items on the list?

Thanks!