公式信息正确显示，但链接信息不正确 [英] 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屋！