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?