Can't delete an external link in EXCEL 1

[SkipVought]

Hi gang,

I know that I have an external link, cuz I get the Yes..No..Cancel window when I open the workbook.

There are no external NAMED references.

There is no reference in VBA References.

When I run...

    For Each link In ActiveWorkbook.LinkSources
        MsgBox link
    Next

I see a single reference to an external workbook in the form, C:\MyWorkbook.xls

I can't do link.Delete or link.Remove.

Any ideas?


Skip,
metzgsk@voughtaircraft.com

 

[dsb]

When I am informed of undesired links (probably caused by me doing some unskillful editing), I usually get rid of them by going to the EDIT>LINKS and changing the source to the file I am working with. This seems to remove the links. In some bizarre cases, it can cause circular references that need to be removed.

dsb

 

[acron]

Skip,

Bill Manville has a great utility (an AddIn) for dealing with external workbook links. You can download it from

http://www.accountingadvisors.com/exdownload.shtml

AC