公式信息显示正确，但链接信息不正确 [英] Formula information displaying correctly, but link information is not

问题描述

在上图中，我在单元格 J1 中放置了以下公式:

In the picture above I have placed the following formula in cell J1:

=HYPERLINK(LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1),LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1))

我最初在本地 C: 驱动器和个人下载文件夹中创建了该文件.然后我在 I4 中创建了超链接公式，并复制下来，建立在路径名 J1 上.当我测试它时，这很好用.

I originally created the file on my local C: drive and personal download folder. I then created hyper link formulas in I4, and copied down, that build on the path name J1. This worked fine and dandy when I tested it.

问题

当我将文件移动到网络驱动器时，单元格 J1 中的值显示了新的新网络路径.但是，当我点击链接时，它会打开我最初创建和保存工作簿的个人下载文件夹.

When I move the file to the network drive, the value in cell J1 showed the new new network path. However when I click on the link it would open my personal download folder where I originally created and saved the workbook.

我的尝试

我认为在移动文件时可能会保存一些未更新的值，因为我使用资源管理器移动文件而不是将打开的工作簿保存在新位置.最后，我尝试将文件保存在新位置，但没有任何效果.我也试过另存为也没有效果.

I thought there might be some value saved some where that was not updated when I moved the file since I used explorer to move the file as opposed to saving the open workbook in a new location. To over come that I tried saving the file in its new location with no effect. I also tried save as with no effect either.

我想要达到的目标

我试图实现一个自动链接，允许用户单击绘图链接，它会打开关联的文件，而不管他们如何映射或引用网络位置.如果文件夹被移动或重命名，它还会自动更新路径.

I was trying to achieve an automatic link that would allow the user to click on the drawing link and it would open the associated file independent of how they have mapped or reference the network location. It would also automatically update the path should the folder be moved or renamed.

出了什么问题?有没有更好的方法来做到这一点?

推荐答案

潜在原因

当使用 =HYPERLINK 公式时，excel 还会生成一个超链接，就像您通过右键单击单元格手动添加的一样.然后，它还使用下划线和蓝色/紫色文本格式化文本.这个手动"创建的超链接位于公式的顶部，因此它首先被选中.正是这个手动"超链接不会更新.

When using the =HYPERLINK formula, excel also generates a hyperlink as if you added one manually by right clicking on the cell. It then also formats the text with an underline and blue/purple text. This "manually" created hyperlink sits on top of the formula so it gets selected first. It is this "manual" hyperlink that does not update.

解决问题

选择所有有问题的单元格.右键单击以显示菜单，然后选择删除超链接.这将删除excel手动"超链接，但保留仍然有效并更新的单元格超链接公式.

Select all cells with the issue. Right click to bring up the menu and then select remove hyperlink. This removes excels "Manual" hyperlink, but leaves the cells hyperlink formula which still works and is updated.

这篇关于公式信息显示正确，但链接信息不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！