1、如果excel提示“此工作簿包含一个或多个无法更新的链接”,可能是该工作簿中链接的文件源被删除或更改位置了。此时可以先点击提示中的“编辑链接”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b50b82caaf58b35e5dde6116e42?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在“编辑链接”界面,会显示链接的源文件名称和状态。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8326cffc1e178a82ccd63507f803738da877e8ab?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在下方会列出源文件所在的文件夹目录。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/79f0f736afc3793166aecc8ee5c4b74542a91156?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、可以根据显示链接的源文件名进行查找,如果找到该文件,可以点击“更改源”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800a04d83ca9bf3533fa828b4753?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击后,会弹出一个浏览窗口,在其中找到目标文件选中即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e850352ac65c103880467b65bc119313b07e8959?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、如果源文件被修改,可点击“打开源文件”。对源文件进行调整。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7003af33a87e950e53d46cb1e385343fbf2b46b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、如果不需要更新当前数据,可点击“断开链接”就可以了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15cefcf955aeb8003af33a87b206?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)