I am trying to create a drop down list and the list is in another workbook. I
followed the help instructions to create the list referencing the cells in
the other workbook. That works fine. But when I try to add a drop down from
data/validation and I type in =ListName it tells me it can't use a list from
another worksheet or workbook. The help clearly says you can.