I'm trying to create a drown down list in excel that is link to a query in
access. Right now i create a list in the workbook I'm working on, then use a
validation option in the Data menu to create the drop down.

I want to use an Acccess file as a central location where people can add new
items to the drop down list. I don't know if this is possible, but if anyone
knows how to do this, please help!!!!!!!!!!!