Figued it out. The selected item is the one highlighted in blue. If the user
merely scrolls through the list but does not highlight the selection, it
"keeps" the old value because it is still selected.

"Frank Hayes" wrote:

Try making the link name explicit in the dropdown dialog box ...
"Sheet1!$A$K$5".

Frank

"Dkline" wrote in message
...
I have a linked cell to an insheet dropdown that loses its connection. The
listbox has "$AK$5" as its linked cell in in its .LinkedCell property.

The list of choices is about 35 names. No matter what I select in the
listbox, it does not change the linked cell.

Anybody else encounter this? What can I do about it?