Excel怎么样编辑外边链接？
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">相信<span style="color: black;">非常多</span>小伙伴在打开表格的时候会<span style="color: black;">显现</span>以下界面，提示<span style="color: black;">没法</span>更新工作簿中的<span style="color: black;">外边</span>链接。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/383508caa79d4f339aa4a0ee9bc2b8df~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1723002819&x-signature=ZCgvVEsXRQBKAJv%2BooXmZIsVnDY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这种<span style="color: black;">状况</span>大多<span style="color: black;">出现</span>在打开别人发送过来的表格时。下面让<span style="color: black;">咱们</span>系统的<span style="color: black;">认识</span>下Excel中的<span style="color: black;">外边</span>链接。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">什么是<span style="color: black;">外边</span>链接</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel中的<span style="color: black;">外边</span>链接<span style="color: black;">重点</span>是<span style="color: black;">咱们</span>引用了其它工作簿中的内容（跨工作簿引用）。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">如下图中所示，<span style="color: black;">咱们</span>需要将表1的年龄字段匹配到表2中去，<span style="color: black;">这般</span>表2中就会存在表1这个<span style="color: black;">外边</span>链接。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/72e2956adbdd4bfcb0d217800bffacea~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1723002819&x-signature=NxxoMr36xd6HWhPnnyKqYGP%2BjSQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>不将引用的公式粘贴为数值，工作表中会<span style="color: black;">始终</span>存在这个引用链接，当被引用单元格（表1）的内容<span style="color: black;">出现</span>改变时，引用单元格（表2）的内容<span style="color: black;">亦</span>会相应<span style="color: black;">出现</span>变化。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">查看<span style="color: black;">外边</span>链接</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">经过</span>点击【<strong style="color: blue;">数据</strong>】—【<strong style="color: blue;">编辑链接</strong>】功能，<span style="color: black;">能够</span>查看当前工作簿中存在的<span style="color: black;">外边</span>链接。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/85b228a4d7874b859fe252b7975faa59~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1723002819&x-signature=jWXtkPfrCQue6Is36Li24wGyULk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在界面的右侧有<strong style="color: blue;">更新值、更改源、打开源文件、断开链接、<span style="color: black;">检测</span>状态</strong>五个按钮。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">更新值</strong>：Excel<span style="color: black;">通常</span>默认自动更新，即<span style="color: black;">外边</span>链接表格内容变动、当前工作簿自动更新；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">更改源</strong>：修改<span style="color: black;">外边</span>链接工作簿；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">打开源文件</strong>：打开<span style="color: black;">外边</span>链接工作簿；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">断开链接</strong>：将表格中的超链接转换成数值格式；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">检测</span>状态</strong>：<span style="color: black;">检测</span><span style="color: black;">外边</span>链接<span style="color: black;">是不是</span>正常，<span style="color: black;">倘若</span><span style="color: black;">外边</span>链接 连接不上，Excel状态会显示“错误：未找到源”，如下图所示：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/f1b9ed3ff874438e9939aa3fecb893a0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1723002819&x-signature=WQVXIocYr02RkIKfs17Iw%2BbPwJE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">查询</span>存在<span style="color: black;">外边</span>链接的单元格</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>要<span style="color: black;">查询</span>当前工作簿中<span style="color: black;">那些</span>单元格中存在<span style="color: black;">外边</span>链接，<span style="color: black;">咱们</span><span style="color: black;">能够</span><span style="color: black;">经过</span><span style="color: black;">查询</span>功能实现。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">上一步中，利用【<strong style="color: blue;">数据</strong>】—【<strong style="color: blue;">编辑链接</strong>】功能<span style="color: black;">能够</span>查看到 <span style="color: black;">外边</span>链接工作簿的名<span style="color: black;">叫作</span>；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Ctrl+C 复制工作簿名<span style="color: black;">叫作</span>，Ctrl+F，Ctrl+V粘贴，将<strong style="color: blue;"><span style="color: black;">查询</span>范围设置为<span style="color: black;">全部</span>工作簿</strong>，点击【<strong style="color: blue;"><span style="color: black;">查询</span><span style="color: black;">所有</span></strong>】；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel就会将存在<span style="color: black;">外边</span>链接的单元格<span style="color: black;">所有</span><span style="color: black;">表示</span>出来。如下图所示：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0be2452a9e8349f3a8c5594bfec9f53e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1723002819&x-signature=wlB4PMAF%2F7SLFUV42%2Bj1oLaKvjU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">外边</span>连接打不开是什么<span style="color: black;">原由</span></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>遇到的、最多的<span style="color: black;">状况</span>是 打不开<span style="color: black;">外边</span>链接、<span style="color: black;">引起</span>数据<span style="color: black;">没法</span>更新，<span style="color: black;">重点</span>有以下3点<span style="color: black;">原由</span>：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、<span style="color: black;">外边</span>链接表格<strong style="color: blue;">被删除</strong>；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<span style="color: black;">外边</span>链接表格<strong style="color: blue;">被重命名或表位置被移动</strong>；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、别人发送的表格，<span style="color: black;">外边</span>链接表格未发过来。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">那样</span><span style="color: black;">怎样</span>更新外部链接？</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">怎样</span>更新<span style="color: black;">外边</span>链接</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">默认<span style="color: black;">状况</span>下，Excel会自动更新<span style="color: black;">外边</span>链接（前提是<span style="color: black;">外边</span>链接的表格存在、且路径名<span style="color: black;">叫作</span>正确），<span style="color: black;">倘若</span>提示<span style="color: black;">没法</span>更新<span style="color: black;">外边</span>链接的话，<span style="color: black;">首要</span><span style="color: black;">咱们</span>需要找回<span style="color: black;">外边</span>链接的表格（<span style="color: black;">或</span>找到对应的替<span style="color: black;">表率</span>）；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">接着在表格中依次点击【数据】—【编辑链接】—【更改源】：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/2c2337f68cb64137a9ab5b99ac6c80ed~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1723002819&x-signature=62VMeguSYHlDnGQnvL3BG%2FEt6jk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>找到恢复的<span style="color: black;">外边</span>链接表格，点击确定<span style="color: black;">就可</span>更新数据。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">写在最后</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">通常</span><span style="color: black;">状况</span>下，<span style="color: black;">咱们</span>在引用<span style="color: black;">外边</span>表格数据之后，要<span style="color: black;">即时</span>断开<span style="color: black;">外边</span>链接，<span style="color: black;">即时</span><strong style="color: blue;">将引用公式复制粘贴为数值</strong>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">外边</span>链接存在<span style="color: black;">非常多</span>不确定<span style="color: black;">原因</span>，<span style="color: black;">倘若</span><span style="color: black;">外边</span>链接的表格数据<span style="color: black;">出现</span>变化，当前表格的内容<span style="color: black;">亦</span>会随着变动；<span style="color: black;">倘若</span><span style="color: black;">外边</span>链接的表格<span style="color: black;">出现</span>变动，当前表格又会弹窗提示<span style="color: black;">没法</span>更新，<span style="color: black;">因此</span>最好将<span style="color: black;">外边</span>链接断开处理。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">小结</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上<span style="color: black;">便是</span>Excel工作簿关于<span style="color: black;">外边</span>链接的<span style="color: black;">有些</span>知识点，分享给<span style="color: black;">大众</span>，<span style="color: black;">期盼</span>有所<span style="color: black;">帮忙</span>~</p>
真情实感，其含义为认真了、走心了的意思，是如今的饭圈常用语。 外链发布社区 http://www.fok120.com/ 你的见解独到，让我受益匪浅，期待更多交流。 回顾过去一年，是艰难的一年；展望未来，是辉煌的一年。
页:
[1]