Hi, I'm hoping someone can help here as I'm driving myself slowly mad with this one. I have created a dynamic list called Employees in a workbook called MyLists and I am trying to use this as data for a drop down box in a separate workbook call Schedule. In Schedule I have Defined the list as follows:

Names in Workbook:MyLists
Refers to = MyLists.xls!Employees

I have then in data validation put list and then:

Validation Source = INDIRECT("[MyLists.xls]Employees")

but all that happens is that I keep getting an error that says

Error=The source currently evaluates to an error. Do you wish to continue?

I have attached the workbooks that I am trying to work this out on. All help very gratefully recieved. Did I mention that I'm going slowly mad with this!