Range Name in Data Validation not working

[Heinrichdp]

I'm trying to create a dynamic drop down list in excel 2016 using Data Validation.

I created Named Tables containing the list details.

I entered the list name in the Data Validation section, but it does not want to except it?

[AliGW]

You'll need to create a named range based on the table range - a bit counter-intuitive, but should work.