删除外部链接 [英] Removing external links

问题描述

我正在使用父级工作簿中的vba创建新的workbook.新创建的workbook的父级workbook具有external link.我尝试断开指向父级工作簿的链接，结果看起来像这样:

I'm creating new workbook using vba from parent workbook. Newly created workbook has external link to it's parent workbook. I try to break the link to parent workbook and result looks like this:

但是，这不能解决我的问题，因为当我打开这个新创建的工作簿时，我仍然收到警告消息:

However, this do not solve my problem as when I open this newly created workbook I still get warning message:

如何不仅断开链接，而且如何删除有关使用VBA进行外部链接的所有信息?

How to not only break the links but also to remove all information about external linking using VBA?

推荐答案

链接可以隐藏在许多地方，包括条件格式，数据验证和外部源.如果您的链接只是指向其他地方的基本公式，则以下内容将其清除:

Links can hide in a number of places, including Conditional Formatting, Data Validation and External Sources. If though, your links are just basic formulae pointing elsewhere then the following will clear them out:

With ActiveWorkbook
    For Each lnk In .LinkSources(Type:=xlLinkTypeExcelLinks)
     .BreakLink Name:=lnk, Type:=xlLinkTypeExcelLinks
    Next
End With

这篇关于删除外部链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！