Issues on dynamic ranges for drowpdown lists in excel

Hi all

i am having issues creating a dymic range for my drop down list in excel

basically, i have started literally reworking the example provided on Excel help page 

this gives the following error message

this is already weird, because all i am doing is reqorking the example, i have tabulated the list as recommended, but this is not even what i want to do, because my range has to be dynamic, if i add items to the table, these should be added in the drop down menu as choosable options. so actually what i want to do is this

as you can see it actually highlights my list, so all is well, one would say.

But then i hit the ok button and the following happens

this is not supposed to happen, excel recognizes the named range, there is no reason why i should get this error message. i have tried several ways, technically, as the table is only one column, i should also be able to just put =Cities in the source box, but everytime i get this error

i actually think this is a flaw in excel. But if i am doing something wrong i am hoping that someone can point out what it is that i am doing wrong here.

i hope the community is able to help me out here

regards

WunterSlaus