In an Excel 2013 sheet, I have a hyperlink that points to a corporate website. When I right-click and choose "edit hyperlink," the following appears in the address box, and it is accurate:
However, regardless of whether I use the left, middle, or right-click to access a hyperlink, the same thing happens: IE11 opens and I receive an http 404 error because the link (which is displayed below) cannot be located.
What might be changing # to%20-%20? This is quite strange considering the URL doesn't have any spaces and %20 is a space.