Debra explains he

http://www.contextures.com/xlDataVal05.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"NJS" wrote in message
...
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.