BreakLink does not seem to work RRS feed

  • Question

  • I'm trying to remove link in Excel 2010 that had been created by copying ranges from other workbooks using the following lines of code in VBA.

    For some reason the links to not get removed and remain. No error message, but no success either.

    Interestingly, when I try to break the link using the Excel user interface, they also remain.

    Any ideas what I'm doing wrong?

    vLinks = gxlbTarget.LinkSources(xlLinkTypeExcelLinks) For Each strLink In vLinks gxlbTarget.BreakLink name:=strLink, Type:=xlLinkTypeExcelLinks Next strLink

    Tuesday, April 3, 2012 4:37 PM


All replies

  • Works for me...  maybe your workbook or worksheet is protected?

    HTH, Bernie

    Tuesday, April 3, 2012 11:31 PM
  • I am not able to break a link. The link shows up in the Data-->Connections-->Edit Links list, but break does not work. The worksheet, workbook are not protected.

    Jwalant Natvarlal Soneji, BE IT, Canada

    Thursday, August 15, 2013 11:30 PM