I've got a spreadsheet that I'm using to communicate via DDE with another
application. I am establishing the DDE links at runtime using the formula
methodoloy in VBA and the Auto_Open event. (i.e.
Worksheet("Sheet1").Range("A1").Formula = "=Citect|Variable!TagName")

The link works perfectly but some time last week I did something to the
worksheet and now every time I open the workbook I get the message stating
that the workbook I opened contains automatic links to information in another
workbook. Do I want to update this information?

I do not know what I did that I'm getting this message now. Each time I
close the workbook I clear the contents of all the known DDE links and I
cannot find the piece of information that is still supposedly connected.

If I acknowledge the dialogue box as YES the workbook opens and my links are
exactly as desired. If I select NO to that dialogue, the cells get populated
with the correct formula but the information doesn't update and I get #REF#
in the cells.

If I check the Links option under Edit the resulting list is exactly what
I'd expect. How can I find what is still linked to eliminate it.

Thanks

Jeff