I have a large spreadsheet with several large drop down lists. The lists are
all in a separate workbook so I have defined a name with an external
reference to the lists. The problem is that the drop down lists will only
work when both spreadsheets are open but I don't want to open the spreadsheet
containing the lists everytime as it is a really large workbook. How can I
get the drop down list to work with just the workbook open where I have
validated the cells?
Thanks.