Hi All.
When I follow the steps to create a dropdown based on a list in another
workbook I get "You may not use references to other workbooks for Data
Validation"?

Does this mean what it says, and is it not possible to use another workbook
as the source? I noticed some discussion between Michael and Massi, but this
didn't answer the primary question?

If I am obliged to refer to a local list linked to an external source, does
this not significantly increase the size of the local workbook?

thanks in advance.