I'm prepping for the Excel Expert 2007 exam & one of the things I need to know is how to "Reference external data in drop-down lists"



I know how to create a data validation drop-down list that references data in another workbook..........is it possible to do it with data from a non-spreadsheet file e.g word or access & if so how do I do so?

TIA

Just to be clear - I know I can import data from non-spreadsheet external sources, but that seems to just put the data into visible cells, it's how to use it in a drop down list that I'm asking for help with.

Thanks