当Excel中单击时，超链接将从＃更改为％20-％20 [英] Hyperlink changes from # to %20-%20 when clicked in Excel

问题描述

我在Excel 2013表中有超链接，链接到内部网站。当我右键点击并选择编辑超链接，我在地址栏中看到这个（这是正确的）：

I've got a hyperlink in an Excel 2013 sheet that links to an internal website. When I right click and select "edit hyperlink", I see this in the address bar (which is correct):

https：// myserver .company.com / home / default.html＃article？id = 1203291003

但是，当我点击左键，中间点击或右键点击 - >打开超链接我得到相同的行为：IE11打开，我得到一个http 404错误，因为没有找到链接（如下所示）。

However, when I left click, middle click, or right click -> open hyperlink I get the same behavior: IE11 opens and I get a http 404 error because the link (shown below) is not found.

https://myserver.company.com/home/default.html%20-%20article?id=1203291003

什么可以将＃转换为％20-％20 ？这很奇怪，因为％20 是一个空格，URL中没有空格。

What could be converting the # to %20-%20? This is very odd because %20 is a space and there are no spaces in the URL.

推荐答案

这是与MS Excel的已知问题。基本上，哈希/磅（ ＃ ）符号是在文件名中使用的有效字符，但在超链接中不被接受办公文件。 ％20-％20 的转换似乎是设计的。

This is a known issue with MS Excel. Basically, the hash/pound (#) sign is a valid character to use in a file name but is not accepted in hyperlinks in Office documents. The conversion to %20-%20 appears to be by design.

但是，看看这个问题，突出显示相同的问题，但使用Excel 2010：

However, take a look at this question, highlighting the same issue but with Excel 2010:

• Excel超链接到具有id或命名锚点的网页位置

• Excel hyperlink to web page location with id or named anchor

这似乎意味着它可能是IE的浏览器问题。如果您可以将其他浏览器设置为默认浏览器，即使临时进行测试也可能会起作用。

which seems to imply it might be a browser issue with IE. If you can set another browser as your default, even temporarily for testing, it might work.

这篇关于当Excel中单击时，超链接将从＃更改为％20-％20的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！