Hyperlink changes from # to %20-%20 when clicked in Excel

Question

(Closed.) This question does not meet Stack Overflow guidelines. It is not currently accepting answers. question from:https://stackoverflow.com/questions/25070176/hyperlink-changes-from-to-20-20-when-clicked-in-excel

Answer 1

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.

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

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

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.