超链接功能不允许我打开超链接

超链接功能不允许我打开超链接

本文介绍了超链接功能不允许我打开超链接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,

我有一个列,其中包含存储在共享网络驱动器中的文件的路径(我的机器本地映射器)。

I have a column that contains paths to files stored in a shared network drive (mapper locally in my machine).

我已经插入了= hyperlink()函数,我可以看到这些单元格正确地被"超链接"了。 (当鼠标滚过指针变成一只手时)。

I have inserted the =hyperlink() function, and I can see that the cells are properly "hyperlinked" (when the mouse roll over the pointer became a little hand).

当我点击单元格时,没有任何事情发生......我怎样才能找到问题所在? ??


非常感谢所有人!

when I click on the cell though, nothing is happening... how can I try to find what the problem is???

Many thanks all!

干杯

推荐答案

我发现如果链接中有任何错误,超链接格式正确,但没有做任何事情。为了调试,我在单独的单元格中构建链接,然后将该单元格作为超链接的条目传递:

I found that if there is any error in the link, the hyperlink formats properly, but does not do anything. To debug, I construct the link in a separate cell, then pass that cell as the entry to the Hyperlink:

= HYPERLINK(AM27,"我的超链接友好名称")

=HYPERLINK(AM27, "My Hyperlink Friendly Name")

其中AM27中的条目将是链接本身(例如
\\ ... \ NetDrive \ UserShares \ MyStuff \ TheFile.pdf)
 或任何需要的公式:

where the entry in AM27 would be the link itself (e.g. \\... \NetDrive\UserShares\MyStuff\TheFile.pdf) or whatever formula is needed:

例如AM27公式=" "

e.g. AM27 formula ="\\... \NetDrive\UserShares\MyStuff\TheFile.pdf"

或=" \\ ...  \NetDrive\UserShares\MyStuff\" &安培; C27& " .pdf "

or ="\\...  \NetDrive\UserShares\MyStuff\" & C27 & ".pdf"

单独从Hyperlinks()函数计算链接可以验证链接,因为您可以右键单击空单元格,选择超链接并输入公式结果(AM27中的内容) 作为'地址'。

Calculating the link separately from the Hyperlinks() function allows you to verify the link because you can right-click on an empty cell, pick hyperlinks and enter the formula result (what is in AM27) as the 'Address'.


这篇关于超链接功能不允许我打开超链接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-19 19:20