Excel hyperlink not redirecting properly (bug?)
I have an Excel hyperlink problem: I click on, let's say A1, copy the link in it (http://www.godaddy.com/domains/searchresults.aspx?ci=54814), right click on hyperlink and copy that SAME URL as the link (if it is not automatically detected and changed).
When I go to click on it, I am redirected to http://www.godaddy.com/domains/search.aspx?ci=53972.
If I copy and paste the link directly into the browser, it works fine (i.e., I am not redirected to a different URL).
Does anyone know what's going on?
microsoft-excel hyperlink
migrated from stackoverflow.com Jul 4 '12 at 20:48
This question came from our site for professional and enthusiast programmers.
add a comment |
I have an Excel hyperlink problem: I click on, let's say A1, copy the link in it (http://www.godaddy.com/domains/searchresults.aspx?ci=54814), right click on hyperlink and copy that SAME URL as the link (if it is not automatically detected and changed).
When I go to click on it, I am redirected to http://www.godaddy.com/domains/search.aspx?ci=53972.
If I copy and paste the link directly into the browser, it works fine (i.e., I am not redirected to a different URL).
Does anyone know what's going on?
microsoft-excel hyperlink
migrated from stackoverflow.com Jul 4 '12 at 20:48
This question came from our site for professional and enthusiast programmers.
2
I ran into the same problem with a URL that requires authentication. If you click from an Excel spreadsheet to a URL that requires you to be logged in to a cookie-based session, most sites will redirect the Microsoft Discovery Agent to a login page. Unless the site is smart enough to redirect the login page request back to the original request in the case that the user is already logged in, you end up being forced to log in manually once the page loads in your real browser. The user experience is that all links appear to be logged-out.
– Joe
Jul 10 '13 at 4:43
add a comment |
I have an Excel hyperlink problem: I click on, let's say A1, copy the link in it (http://www.godaddy.com/domains/searchresults.aspx?ci=54814), right click on hyperlink and copy that SAME URL as the link (if it is not automatically detected and changed).
When I go to click on it, I am redirected to http://www.godaddy.com/domains/search.aspx?ci=53972.
If I copy and paste the link directly into the browser, it works fine (i.e., I am not redirected to a different URL).
Does anyone know what's going on?
microsoft-excel hyperlink
I have an Excel hyperlink problem: I click on, let's say A1, copy the link in it (http://www.godaddy.com/domains/searchresults.aspx?ci=54814), right click on hyperlink and copy that SAME URL as the link (if it is not automatically detected and changed).
When I go to click on it, I am redirected to http://www.godaddy.com/domains/search.aspx?ci=53972.
If I copy and paste the link directly into the browser, it works fine (i.e., I am not redirected to a different URL).
Does anyone know what's going on?
microsoft-excel hyperlink
microsoft-excel hyperlink
edited Jul 18 '14 at 15:05
That Brazilian Guy
4,73675190
4,73675190
asked Jul 4 '12 at 5:14
Andrej
236134
236134
migrated from stackoverflow.com Jul 4 '12 at 20:48
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Jul 4 '12 at 20:48
This question came from our site for professional and enthusiast programmers.
2
I ran into the same problem with a URL that requires authentication. If you click from an Excel spreadsheet to a URL that requires you to be logged in to a cookie-based session, most sites will redirect the Microsoft Discovery Agent to a login page. Unless the site is smart enough to redirect the login page request back to the original request in the case that the user is already logged in, you end up being forced to log in manually once the page loads in your real browser. The user experience is that all links appear to be logged-out.
– Joe
Jul 10 '13 at 4:43
add a comment |
2
I ran into the same problem with a URL that requires authentication. If you click from an Excel spreadsheet to a URL that requires you to be logged in to a cookie-based session, most sites will redirect the Microsoft Discovery Agent to a login page. Unless the site is smart enough to redirect the login page request back to the original request in the case that the user is already logged in, you end up being forced to log in manually once the page loads in your real browser. The user experience is that all links appear to be logged-out.
– Joe
Jul 10 '13 at 4:43
2
2
I ran into the same problem with a URL that requires authentication. If you click from an Excel spreadsheet to a URL that requires you to be logged in to a cookie-based session, most sites will redirect the Microsoft Discovery Agent to a login page. Unless the site is smart enough to redirect the login page request back to the original request in the case that the user is already logged in, you end up being forced to log in manually once the page loads in your real browser. The user experience is that all links appear to be logged-out.
– Joe
Jul 10 '13 at 4:43
I ran into the same problem with a URL that requires authentication. If you click from an Excel spreadsheet to a URL that requires you to be logged in to a cookie-based session, most sites will redirect the Microsoft Discovery Agent to a login page. Unless the site is smart enough to redirect the login page request back to the original request in the case that the user is already logged in, you end up being forced to log in manually once the page loads in your real browser. The user experience is that all links appear to be logged-out.
– Joe
Jul 10 '13 at 4:43
add a comment |
13 Answers
13
active
oldest
votes
The URL you're using needs some more information from a cookie to display the search results rather than the search page. Paste the URL into a different browser (or remove your cookies) and you'll get the same results.
Clicking a URL in Excel seems to open it in your default browser. But that's not really true. Before opening it in your browser, Excel first runs Microsoft Office Protocol Discovery. This uses a Windows/Internet Explorer component to determine if the URL works. (It does not identify itself as Internet Explorer, but as "User Agent: Microsoft Office Existence Discovery".) And if the results are (somehow) okay then it will open the result of that check in your default browser.
Lacking the cookies (more precisely: lacking a session), GoDaddy gives that Internet Explorer component some redirect. And the result of that is opened in your default browser. That's the URL you're seeing.
Most likely your default browser is not Internet Explorer? Then pasting the URL into IE directly and clicking it, to get the cookies, might then also make the link work from Excel. (Just for testing; it's not a permanent solution.)
You will have more luck using a URL that does not rely on some hidden information from a cookie, like http://www.godaddy.com/domains/search.aspx?domainToCheck=superuser.com
Great information, thank you. I'm seeing the same in Word when opening a link for which you must be logged in.
– marcvangend
Aug 11 '15 at 11:41
1
This should be marked as the correct answer.
– Selosindis
May 31 '16 at 18:00
what a "feature"
– CountMurphy
Jan 17 at 18:27
add a comment |
This is Excel fault. If you paste the link in Outlook email or WordPad and you open the link from there it will work correctly.
Excel should never create hidden session to verify the hyperlink. what's the point of it. It just needs to open it, nothing else. They use the same logic in MS Word. It doesn't work from there neither.
When Excel tries to verify the link in the background, new session is created that is not authenticated so it gets redirected to login page or something. After that instead of opening the original URL in the browser, Excel is opening the redirection url. They really know how to make simple thing complicated.
It's not Excel that is creating sessions. It's the GoDaddy website that does that. Copying the URL from one browser to another will also NOT get one the search results. Using the Excel workbook on another computer will also fail. (Apart from that: indeed Excel is messing up by trying to be smart; see the other answers for more background info.)
– Arjan
Dec 12 '12 at 18:35
add a comment |
This is a known Microsoft bug where hyperlinks are redirected to another page if:
- You are using Microsoft Internet Explorer:
- with a proxy server
- while using a firewall that does not allow HTTP requests on your local network
- Internet Explorer is not your default browser.
- The
ForceShellExecuteregistry key is not present or is not set to 1
You can apply the fix from here:
http://support.microsoft.com/kb/218153
This fix also solved a related problem for me. When clicking links in PowerPoint, I would sometimes get the error message "cannot download the information you requested". Applying the fix at that link resolved the issue. Note that I am using PowerPoint 2010 on a Windows 10 machine with Chrome (v 60) as my default browser.
– Paul de Barros
Aug 14 '17 at 8:48
add a comment |
Too much here to add as a comment I'm afraid.
The initial link returns a 302 status code
From the w3c standards:
The requested resource resides temporarily under a different URI.
Since the redirection might be altered on occasion, the client SHOULD
continue to use the Request-URI for future requests. This response is
only cacheable if indicated by a Cache-Control or Expires header
field.
The temporary URI SHOULD be given by the Location field in the
response. Unless the request method was HEAD, the entity of the
response SHOULD contain a short hypertext note with a hyperlink to the
new URI(s).
If the 302 status code is received in response to a request other than
GET or HEAD, the user agent MUST NOT automatically redirect the
request unless it can be confirmed by the user, since this might
change the conditions under which the request was issued.
Note: RFC 1945 and RFC 2068 specify that the client is not allowed
to change the method on the redirected request. However, most
existing user agent implementations treat 302 as if it were a 303
response, performing a GET on the Location field-value regardless
of the original request method. The status codes 303 and 307 have
been added for servers that wish to make unambiguously clear which
kind of reaction is expected of the client.
So as @xlm stated, this is GoDaddy doing a temporary redirect.
It would seem that, when called from Excel, the redirect is not always being honoured.
1
I'd have added this as a comment to @xlm's answer but it's too big. I realise that this isn't an answer.
– Julian Knight
Jul 6 '12 at 9:59
add a comment |
It's definitely annoying. One workaround is to make link to a local file that redirects to the hyperlink. For example, something like:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0;URL=http://www.google.com">
</HEAD>
<BODY>
Redirecting...
</BODY>
</HTML>
I don't know much about HTML, but it would be nice to be able to pass an argument (ie, the URL) to this local html file.
add a comment |
I can replicate your problem however it's not an Excel issue.
It is actually Godaddy that is redirecting you to the second link.
Try pasting that link into your browser and you will see it redirect to the second one.
Notes:Tested on Excel 2007, Firefox 13.0.1
1
hm.. but when I paste the link into the browser I stay on the first link.. that is why it's wierd.. how is godaddy able to detect the diference between pasting the link in the url or navigating from an excel file?
– Andrej
Jul 4 '12 at 5:27
They aren't, basically when your browser attempts to visit the first link, their server responds by sending you to the second. It has nothing to do with Excel. I've verified this on Chrome as well. I can't reproduce the circumstances you describe where you enter it on your browser and it doesn't redirect. What browser are you using?
– xlm
Jul 4 '12 at 5:31
i'm using Chrome, but I see what's going on now.. the request is session based.. so when i open from another browser, i can't see the link.. and somehow the session is broken when accessing from teh excel file..
– Andrej
Jul 4 '12 at 5:32
Try reproducing those circumstances again with Chrome, I'm quite sure you'll end up at the second link. Excel is just opening the link with your default browser. Also if this resolves your Q please mark it thanks!
– xlm
Jul 4 '12 at 5:34
1
sorry but it doesn't resolve the issue.. excel opens the link with chrome too, that's why it's wierd..when i paste that same link in chrome - it works.. but when i click on hyperlink it doesn't... when i open it in chrome in incognito, it also doesn't work...
– Andrej
Jul 4 '12 at 5:45
add a comment |
I had the same problem only the site I was going to included processing and retrieving data base on a date stamp.
I would copy the url to a new cell.
change the date.
click on the new url, BUT get the old url.
However, if I ctl clicked on the new url cell,
go up to the cell display window
click my cursor anywhere in that window
then click on a different cell
the url date values change
and clicking on the url gets me the right data.
All this in IE.
It appears that when you copy the url it brings the url site info with it.
Not sure what magic happens when I open the cell and don't alter it, but it changes the url when you put your pointer over it.
I'm a regular magnet for this kind of stuff in Excel. Probably why I don't trust it.
add a comment |
I found this problem crops up when the target URL is a secure site that required a login. Even though I am logged in already in a different window, it will not work properly. If I cut and paste the URL in a new tab or window, Chrome is smart enough to find that I have already authenticated and opens the new page properly. However, If I’m not logged in to the site, I will get redirected to the login page, as expected.
But when clicking the exact same URL in Excel, with the same conditions, I either get the login page only, or my remote site just tells me it is an unsupported browser.
The problem is clearly coming from Excel, because if I take that exact spreadsheet, save it as a PDF, the hyperlinks that display in the PDF work perfectly fine when clicked.
Other than fixing this obviously unintended “feature” of Excel/Office trying to verify links as others have posted, the only workaround that I found was to create a local redirect page which could take my unique parameters within the URL and open a new window as follows (thanks to others for the JavaScript code)
Redirect by changing the excel hyperlink to something like
http://mylocaldomain.com/redirect.html?ID=12345,
where the redirect page is on a local server you control and the parameter 12345 makes the URL redirect to the particular entry needed. For my SS with about 10000 links this works just fine.
Redirect.html is as follows.
<!DOCTYPE html>
<html>
<script>
function getUrlVars() {
var vars = {};
var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi,
function(m,key,value) {
vars[key] = value;
});
return vars;
}
document.getElementById("demo").innerHTML=getUrlVars()["type"];
var varbaseurl=[put your base url here]
window.location = varbaseURL + getUrlVars()["type"]
</script>
<body>
redirecting to: <p id=demo></p>
add a comment |
I solved this by doing a google search on the Url and using the google results page url for the hyperlink
e.g. for sweettoothrewards.com
I used https://www.google.ca/?gfe_rd=cr&ei=xwK5VY-LG8KC8QeGn4LoDw&gws_rd=ssl#q=+sweettoothrewards.com In opera browser with me not signed in.
add a comment |
I was able to investigate this further as I was trying to get an Excel workbook to link to my own web server. I noticed that clicking a link in Excel produced three queries to the server.
- GET HEAD (with temporary session)
- GET (with temporary session)
- GET (with real session)
But if the linked page was redirecting the user I didn't see the third GET. Instead the second GET was redirected to a new page and the session remained temporary. Which means that if the target page requires authentication the user will be redirected to a login page even if he actually is already authenticated.
This lead me to an idea to create a landing page that redirects the user to the target page if the user is authenticated. And it works. When the third GET is received the server notices that the user is authenticated and redirects to the target page. For unauthenticated user the landing page shows a link to the target page. And when the user clicks the link the user will be redirected to sign in page.
add a comment |
We manage to reproduce the problem and our developer findings indicate when you paste a link into Microsoft Excel, Excel prefaces the link with a byte order mark (BOM). When this link is loaded in the browser, it does not remove the BOM from the URL.
Upon loading the URL, the browser does several tests verify that the connection is secure (https) and this is failing due to the errant BOM. This ultimately causes the relay state error, since that parameter must be sent over a secure channel.
You can reproduce this problem by copying the cell and pasting it directly into firefox, thereby taking Excel out of the picture. This also fails (sometimes in a slightly different way) but suffers from the same root problem. If you remove the "https" from the pasted URL and simply retype it, you will notice that the link now works correctly.
This is a limitation in the fact that Excel stores the BOM in the URL, and the way in which the browser cannot interpret the BOM.
At the moment the only workaround we could think of is copy the URL link and paste it over to the browser and access the page.
Also, I would personally suggest you to raise a support ticket with Microsoft and I believe they might have better understanding on this issue to help you on this matter.
add a comment |
To solve this issue on some sites I just create an HTML file that redirects to the site in question, and then point the hyperlink in Excel to this file and it works great..
sample:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0; URL=https://citiretailservices.citibankonline.com/RSnextgen/svc/launch/index.action?siteId=PLCN_GOODYEAR&langId=en_US#signon">
</HEAD>
<BODY>
Custom Redirect by Jason...
</BODY>
</HTML>
add a comment |
I recently had this issue where a hyperlink function in Excel pointed to a redirect 301 in a WordPress site. I updated the 301 to point to a new document but the link in Excel continued to bring up the old document. I was only able to resolve this by clearing the document cache in IE, even though I am running Excel 2016 on a Windows 10 machine. Hope this helps.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f444984%2fexcel-hyperlink-not-redirecting-properly-bug%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
13 Answers
13
active
oldest
votes
13 Answers
13
active
oldest
votes
active
oldest
votes
active
oldest
votes
The URL you're using needs some more information from a cookie to display the search results rather than the search page. Paste the URL into a different browser (or remove your cookies) and you'll get the same results.
Clicking a URL in Excel seems to open it in your default browser. But that's not really true. Before opening it in your browser, Excel first runs Microsoft Office Protocol Discovery. This uses a Windows/Internet Explorer component to determine if the URL works. (It does not identify itself as Internet Explorer, but as "User Agent: Microsoft Office Existence Discovery".) And if the results are (somehow) okay then it will open the result of that check in your default browser.
Lacking the cookies (more precisely: lacking a session), GoDaddy gives that Internet Explorer component some redirect. And the result of that is opened in your default browser. That's the URL you're seeing.
Most likely your default browser is not Internet Explorer? Then pasting the URL into IE directly and clicking it, to get the cookies, might then also make the link work from Excel. (Just for testing; it's not a permanent solution.)
You will have more luck using a URL that does not rely on some hidden information from a cookie, like http://www.godaddy.com/domains/search.aspx?domainToCheck=superuser.com
Great information, thank you. I'm seeing the same in Word when opening a link for which you must be logged in.
– marcvangend
Aug 11 '15 at 11:41
1
This should be marked as the correct answer.
– Selosindis
May 31 '16 at 18:00
what a "feature"
– CountMurphy
Jan 17 at 18:27
add a comment |
The URL you're using needs some more information from a cookie to display the search results rather than the search page. Paste the URL into a different browser (or remove your cookies) and you'll get the same results.
Clicking a URL in Excel seems to open it in your default browser. But that's not really true. Before opening it in your browser, Excel first runs Microsoft Office Protocol Discovery. This uses a Windows/Internet Explorer component to determine if the URL works. (It does not identify itself as Internet Explorer, but as "User Agent: Microsoft Office Existence Discovery".) And if the results are (somehow) okay then it will open the result of that check in your default browser.
Lacking the cookies (more precisely: lacking a session), GoDaddy gives that Internet Explorer component some redirect. And the result of that is opened in your default browser. That's the URL you're seeing.
Most likely your default browser is not Internet Explorer? Then pasting the URL into IE directly and clicking it, to get the cookies, might then also make the link work from Excel. (Just for testing; it's not a permanent solution.)
You will have more luck using a URL that does not rely on some hidden information from a cookie, like http://www.godaddy.com/domains/search.aspx?domainToCheck=superuser.com
Great information, thank you. I'm seeing the same in Word when opening a link for which you must be logged in.
– marcvangend
Aug 11 '15 at 11:41
1
This should be marked as the correct answer.
– Selosindis
May 31 '16 at 18:00
what a "feature"
– CountMurphy
Jan 17 at 18:27
add a comment |
The URL you're using needs some more information from a cookie to display the search results rather than the search page. Paste the URL into a different browser (or remove your cookies) and you'll get the same results.
Clicking a URL in Excel seems to open it in your default browser. But that's not really true. Before opening it in your browser, Excel first runs Microsoft Office Protocol Discovery. This uses a Windows/Internet Explorer component to determine if the URL works. (It does not identify itself as Internet Explorer, but as "User Agent: Microsoft Office Existence Discovery".) And if the results are (somehow) okay then it will open the result of that check in your default browser.
Lacking the cookies (more precisely: lacking a session), GoDaddy gives that Internet Explorer component some redirect. And the result of that is opened in your default browser. That's the URL you're seeing.
Most likely your default browser is not Internet Explorer? Then pasting the URL into IE directly and clicking it, to get the cookies, might then also make the link work from Excel. (Just for testing; it's not a permanent solution.)
You will have more luck using a URL that does not rely on some hidden information from a cookie, like http://www.godaddy.com/domains/search.aspx?domainToCheck=superuser.com
The URL you're using needs some more information from a cookie to display the search results rather than the search page. Paste the URL into a different browser (or remove your cookies) and you'll get the same results.
Clicking a URL in Excel seems to open it in your default browser. But that's not really true. Before opening it in your browser, Excel first runs Microsoft Office Protocol Discovery. This uses a Windows/Internet Explorer component to determine if the URL works. (It does not identify itself as Internet Explorer, but as "User Agent: Microsoft Office Existence Discovery".) And if the results are (somehow) okay then it will open the result of that check in your default browser.
Lacking the cookies (more precisely: lacking a session), GoDaddy gives that Internet Explorer component some redirect. And the result of that is opened in your default browser. That's the URL you're seeing.
Most likely your default browser is not Internet Explorer? Then pasting the URL into IE directly and clicking it, to get the cookies, might then also make the link work from Excel. (Just for testing; it's not a permanent solution.)
You will have more luck using a URL that does not rely on some hidden information from a cookie, like http://www.godaddy.com/domains/search.aspx?domainToCheck=superuser.com
edited Jul 5 '12 at 20:40
answered Jul 5 '12 at 20:11
Arjan
26.8k1065107
26.8k1065107
Great information, thank you. I'm seeing the same in Word when opening a link for which you must be logged in.
– marcvangend
Aug 11 '15 at 11:41
1
This should be marked as the correct answer.
– Selosindis
May 31 '16 at 18:00
what a "feature"
– CountMurphy
Jan 17 at 18:27
add a comment |
Great information, thank you. I'm seeing the same in Word when opening a link for which you must be logged in.
– marcvangend
Aug 11 '15 at 11:41
1
This should be marked as the correct answer.
– Selosindis
May 31 '16 at 18:00
what a "feature"
– CountMurphy
Jan 17 at 18:27
Great information, thank you. I'm seeing the same in Word when opening a link for which you must be logged in.
– marcvangend
Aug 11 '15 at 11:41
Great information, thank you. I'm seeing the same in Word when opening a link for which you must be logged in.
– marcvangend
Aug 11 '15 at 11:41
1
1
This should be marked as the correct answer.
– Selosindis
May 31 '16 at 18:00
This should be marked as the correct answer.
– Selosindis
May 31 '16 at 18:00
what a "feature"
– CountMurphy
Jan 17 at 18:27
what a "feature"
– CountMurphy
Jan 17 at 18:27
add a comment |
This is Excel fault. If you paste the link in Outlook email or WordPad and you open the link from there it will work correctly.
Excel should never create hidden session to verify the hyperlink. what's the point of it. It just needs to open it, nothing else. They use the same logic in MS Word. It doesn't work from there neither.
When Excel tries to verify the link in the background, new session is created that is not authenticated so it gets redirected to login page or something. After that instead of opening the original URL in the browser, Excel is opening the redirection url. They really know how to make simple thing complicated.
It's not Excel that is creating sessions. It's the GoDaddy website that does that. Copying the URL from one browser to another will also NOT get one the search results. Using the Excel workbook on another computer will also fail. (Apart from that: indeed Excel is messing up by trying to be smart; see the other answers for more background info.)
– Arjan
Dec 12 '12 at 18:35
add a comment |
This is Excel fault. If you paste the link in Outlook email or WordPad and you open the link from there it will work correctly.
Excel should never create hidden session to verify the hyperlink. what's the point of it. It just needs to open it, nothing else. They use the same logic in MS Word. It doesn't work from there neither.
When Excel tries to verify the link in the background, new session is created that is not authenticated so it gets redirected to login page or something. After that instead of opening the original URL in the browser, Excel is opening the redirection url. They really know how to make simple thing complicated.
It's not Excel that is creating sessions. It's the GoDaddy website that does that. Copying the URL from one browser to another will also NOT get one the search results. Using the Excel workbook on another computer will also fail. (Apart from that: indeed Excel is messing up by trying to be smart; see the other answers for more background info.)
– Arjan
Dec 12 '12 at 18:35
add a comment |
This is Excel fault. If you paste the link in Outlook email or WordPad and you open the link from there it will work correctly.
Excel should never create hidden session to verify the hyperlink. what's the point of it. It just needs to open it, nothing else. They use the same logic in MS Word. It doesn't work from there neither.
When Excel tries to verify the link in the background, new session is created that is not authenticated so it gets redirected to login page or something. After that instead of opening the original URL in the browser, Excel is opening the redirection url. They really know how to make simple thing complicated.
This is Excel fault. If you paste the link in Outlook email or WordPad and you open the link from there it will work correctly.
Excel should never create hidden session to verify the hyperlink. what's the point of it. It just needs to open it, nothing else. They use the same logic in MS Word. It doesn't work from there neither.
When Excel tries to verify the link in the background, new session is created that is not authenticated so it gets redirected to login page or something. After that instead of opening the original URL in the browser, Excel is opening the redirection url. They really know how to make simple thing complicated.
answered Dec 5 '12 at 22:25
fry
10912
10912
It's not Excel that is creating sessions. It's the GoDaddy website that does that. Copying the URL from one browser to another will also NOT get one the search results. Using the Excel workbook on another computer will also fail. (Apart from that: indeed Excel is messing up by trying to be smart; see the other answers for more background info.)
– Arjan
Dec 12 '12 at 18:35
add a comment |
It's not Excel that is creating sessions. It's the GoDaddy website that does that. Copying the URL from one browser to another will also NOT get one the search results. Using the Excel workbook on another computer will also fail. (Apart from that: indeed Excel is messing up by trying to be smart; see the other answers for more background info.)
– Arjan
Dec 12 '12 at 18:35
It's not Excel that is creating sessions. It's the GoDaddy website that does that. Copying the URL from one browser to another will also NOT get one the search results. Using the Excel workbook on another computer will also fail. (Apart from that: indeed Excel is messing up by trying to be smart; see the other answers for more background info.)
– Arjan
Dec 12 '12 at 18:35
It's not Excel that is creating sessions. It's the GoDaddy website that does that. Copying the URL from one browser to another will also NOT get one the search results. Using the Excel workbook on another computer will also fail. (Apart from that: indeed Excel is messing up by trying to be smart; see the other answers for more background info.)
– Arjan
Dec 12 '12 at 18:35
add a comment |
This is a known Microsoft bug where hyperlinks are redirected to another page if:
- You are using Microsoft Internet Explorer:
- with a proxy server
- while using a firewall that does not allow HTTP requests on your local network
- Internet Explorer is not your default browser.
- The
ForceShellExecuteregistry key is not present or is not set to 1
You can apply the fix from here:
http://support.microsoft.com/kb/218153
This fix also solved a related problem for me. When clicking links in PowerPoint, I would sometimes get the error message "cannot download the information you requested". Applying the fix at that link resolved the issue. Note that I am using PowerPoint 2010 on a Windows 10 machine with Chrome (v 60) as my default browser.
– Paul de Barros
Aug 14 '17 at 8:48
add a comment |
This is a known Microsoft bug where hyperlinks are redirected to another page if:
- You are using Microsoft Internet Explorer:
- with a proxy server
- while using a firewall that does not allow HTTP requests on your local network
- Internet Explorer is not your default browser.
- The
ForceShellExecuteregistry key is not present or is not set to 1
You can apply the fix from here:
http://support.microsoft.com/kb/218153
This fix also solved a related problem for me. When clicking links in PowerPoint, I would sometimes get the error message "cannot download the information you requested". Applying the fix at that link resolved the issue. Note that I am using PowerPoint 2010 on a Windows 10 machine with Chrome (v 60) as my default browser.
– Paul de Barros
Aug 14 '17 at 8:48
add a comment |
This is a known Microsoft bug where hyperlinks are redirected to another page if:
- You are using Microsoft Internet Explorer:
- with a proxy server
- while using a firewall that does not allow HTTP requests on your local network
- Internet Explorer is not your default browser.
- The
ForceShellExecuteregistry key is not present or is not set to 1
You can apply the fix from here:
http://support.microsoft.com/kb/218153
This is a known Microsoft bug where hyperlinks are redirected to another page if:
- You are using Microsoft Internet Explorer:
- with a proxy server
- while using a firewall that does not allow HTTP requests on your local network
- Internet Explorer is not your default browser.
- The
ForceShellExecuteregistry key is not present or is not set to 1
You can apply the fix from here:
http://support.microsoft.com/kb/218153
edited Oct 7 '16 at 7:53
Lurker_Lurks
32
32
answered Oct 14 '14 at 8:23
Kaushik Baruah
6111
6111
This fix also solved a related problem for me. When clicking links in PowerPoint, I would sometimes get the error message "cannot download the information you requested". Applying the fix at that link resolved the issue. Note that I am using PowerPoint 2010 on a Windows 10 machine with Chrome (v 60) as my default browser.
– Paul de Barros
Aug 14 '17 at 8:48
add a comment |
This fix also solved a related problem for me. When clicking links in PowerPoint, I would sometimes get the error message "cannot download the information you requested". Applying the fix at that link resolved the issue. Note that I am using PowerPoint 2010 on a Windows 10 machine with Chrome (v 60) as my default browser.
– Paul de Barros
Aug 14 '17 at 8:48
This fix also solved a related problem for me. When clicking links in PowerPoint, I would sometimes get the error message "cannot download the information you requested". Applying the fix at that link resolved the issue. Note that I am using PowerPoint 2010 on a Windows 10 machine with Chrome (v 60) as my default browser.
– Paul de Barros
Aug 14 '17 at 8:48
This fix also solved a related problem for me. When clicking links in PowerPoint, I would sometimes get the error message "cannot download the information you requested". Applying the fix at that link resolved the issue. Note that I am using PowerPoint 2010 on a Windows 10 machine with Chrome (v 60) as my default browser.
– Paul de Barros
Aug 14 '17 at 8:48
add a comment |
Too much here to add as a comment I'm afraid.
The initial link returns a 302 status code
From the w3c standards:
The requested resource resides temporarily under a different URI.
Since the redirection might be altered on occasion, the client SHOULD
continue to use the Request-URI for future requests. This response is
only cacheable if indicated by a Cache-Control or Expires header
field.
The temporary URI SHOULD be given by the Location field in the
response. Unless the request method was HEAD, the entity of the
response SHOULD contain a short hypertext note with a hyperlink to the
new URI(s).
If the 302 status code is received in response to a request other than
GET or HEAD, the user agent MUST NOT automatically redirect the
request unless it can be confirmed by the user, since this might
change the conditions under which the request was issued.
Note: RFC 1945 and RFC 2068 specify that the client is not allowed
to change the method on the redirected request. However, most
existing user agent implementations treat 302 as if it were a 303
response, performing a GET on the Location field-value regardless
of the original request method. The status codes 303 and 307 have
been added for servers that wish to make unambiguously clear which
kind of reaction is expected of the client.
So as @xlm stated, this is GoDaddy doing a temporary redirect.
It would seem that, when called from Excel, the redirect is not always being honoured.
1
I'd have added this as a comment to @xlm's answer but it's too big. I realise that this isn't an answer.
– Julian Knight
Jul 6 '12 at 9:59
add a comment |
Too much here to add as a comment I'm afraid.
The initial link returns a 302 status code
From the w3c standards:
The requested resource resides temporarily under a different URI.
Since the redirection might be altered on occasion, the client SHOULD
continue to use the Request-URI for future requests. This response is
only cacheable if indicated by a Cache-Control or Expires header
field.
The temporary URI SHOULD be given by the Location field in the
response. Unless the request method was HEAD, the entity of the
response SHOULD contain a short hypertext note with a hyperlink to the
new URI(s).
If the 302 status code is received in response to a request other than
GET or HEAD, the user agent MUST NOT automatically redirect the
request unless it can be confirmed by the user, since this might
change the conditions under which the request was issued.
Note: RFC 1945 and RFC 2068 specify that the client is not allowed
to change the method on the redirected request. However, most
existing user agent implementations treat 302 as if it were a 303
response, performing a GET on the Location field-value regardless
of the original request method. The status codes 303 and 307 have
been added for servers that wish to make unambiguously clear which
kind of reaction is expected of the client.
So as @xlm stated, this is GoDaddy doing a temporary redirect.
It would seem that, when called from Excel, the redirect is not always being honoured.
1
I'd have added this as a comment to @xlm's answer but it's too big. I realise that this isn't an answer.
– Julian Knight
Jul 6 '12 at 9:59
add a comment |
Too much here to add as a comment I'm afraid.
The initial link returns a 302 status code
From the w3c standards:
The requested resource resides temporarily under a different URI.
Since the redirection might be altered on occasion, the client SHOULD
continue to use the Request-URI for future requests. This response is
only cacheable if indicated by a Cache-Control or Expires header
field.
The temporary URI SHOULD be given by the Location field in the
response. Unless the request method was HEAD, the entity of the
response SHOULD contain a short hypertext note with a hyperlink to the
new URI(s).
If the 302 status code is received in response to a request other than
GET or HEAD, the user agent MUST NOT automatically redirect the
request unless it can be confirmed by the user, since this might
change the conditions under which the request was issued.
Note: RFC 1945 and RFC 2068 specify that the client is not allowed
to change the method on the redirected request. However, most
existing user agent implementations treat 302 as if it were a 303
response, performing a GET on the Location field-value regardless
of the original request method. The status codes 303 and 307 have
been added for servers that wish to make unambiguously clear which
kind of reaction is expected of the client.
So as @xlm stated, this is GoDaddy doing a temporary redirect.
It would seem that, when called from Excel, the redirect is not always being honoured.
Too much here to add as a comment I'm afraid.
The initial link returns a 302 status code
From the w3c standards:
The requested resource resides temporarily under a different URI.
Since the redirection might be altered on occasion, the client SHOULD
continue to use the Request-URI for future requests. This response is
only cacheable if indicated by a Cache-Control or Expires header
field.
The temporary URI SHOULD be given by the Location field in the
response. Unless the request method was HEAD, the entity of the
response SHOULD contain a short hypertext note with a hyperlink to the
new URI(s).
If the 302 status code is received in response to a request other than
GET or HEAD, the user agent MUST NOT automatically redirect the
request unless it can be confirmed by the user, since this might
change the conditions under which the request was issued.
Note: RFC 1945 and RFC 2068 specify that the client is not allowed
to change the method on the redirected request. However, most
existing user agent implementations treat 302 as if it were a 303
response, performing a GET on the Location field-value regardless
of the original request method. The status codes 303 and 307 have
been added for servers that wish to make unambiguously clear which
kind of reaction is expected of the client.
So as @xlm stated, this is GoDaddy doing a temporary redirect.
It would seem that, when called from Excel, the redirect is not always being honoured.
answered Jul 5 '12 at 16:44
Julian Knight
12.9k11535
12.9k11535
1
I'd have added this as a comment to @xlm's answer but it's too big. I realise that this isn't an answer.
– Julian Knight
Jul 6 '12 at 9:59
add a comment |
1
I'd have added this as a comment to @xlm's answer but it's too big. I realise that this isn't an answer.
– Julian Knight
Jul 6 '12 at 9:59
1
1
I'd have added this as a comment to @xlm's answer but it's too big. I realise that this isn't an answer.
– Julian Knight
Jul 6 '12 at 9:59
I'd have added this as a comment to @xlm's answer but it's too big. I realise that this isn't an answer.
– Julian Knight
Jul 6 '12 at 9:59
add a comment |
It's definitely annoying. One workaround is to make link to a local file that redirects to the hyperlink. For example, something like:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0;URL=http://www.google.com">
</HEAD>
<BODY>
Redirecting...
</BODY>
</HTML>
I don't know much about HTML, but it would be nice to be able to pass an argument (ie, the URL) to this local html file.
add a comment |
It's definitely annoying. One workaround is to make link to a local file that redirects to the hyperlink. For example, something like:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0;URL=http://www.google.com">
</HEAD>
<BODY>
Redirecting...
</BODY>
</HTML>
I don't know much about HTML, but it would be nice to be able to pass an argument (ie, the URL) to this local html file.
add a comment |
It's definitely annoying. One workaround is to make link to a local file that redirects to the hyperlink. For example, something like:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0;URL=http://www.google.com">
</HEAD>
<BODY>
Redirecting...
</BODY>
</HTML>
I don't know much about HTML, but it would be nice to be able to pass an argument (ie, the URL) to this local html file.
It's definitely annoying. One workaround is to make link to a local file that redirects to the hyperlink. For example, something like:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0;URL=http://www.google.com">
</HEAD>
<BODY>
Redirecting...
</BODY>
</HTML>
I don't know much about HTML, but it would be nice to be able to pass an argument (ie, the URL) to this local html file.
edited Oct 25 '15 at 17:13
answered Oct 19 '15 at 21:21
q335r49
1112
1112
add a comment |
add a comment |
I can replicate your problem however it's not an Excel issue.
It is actually Godaddy that is redirecting you to the second link.
Try pasting that link into your browser and you will see it redirect to the second one.
Notes:Tested on Excel 2007, Firefox 13.0.1
1
hm.. but when I paste the link into the browser I stay on the first link.. that is why it's wierd.. how is godaddy able to detect the diference between pasting the link in the url or navigating from an excel file?
– Andrej
Jul 4 '12 at 5:27
They aren't, basically when your browser attempts to visit the first link, their server responds by sending you to the second. It has nothing to do with Excel. I've verified this on Chrome as well. I can't reproduce the circumstances you describe where you enter it on your browser and it doesn't redirect. What browser are you using?
– xlm
Jul 4 '12 at 5:31
i'm using Chrome, but I see what's going on now.. the request is session based.. so when i open from another browser, i can't see the link.. and somehow the session is broken when accessing from teh excel file..
– Andrej
Jul 4 '12 at 5:32
Try reproducing those circumstances again with Chrome, I'm quite sure you'll end up at the second link. Excel is just opening the link with your default browser. Also if this resolves your Q please mark it thanks!
– xlm
Jul 4 '12 at 5:34
1
sorry but it doesn't resolve the issue.. excel opens the link with chrome too, that's why it's wierd..when i paste that same link in chrome - it works.. but when i click on hyperlink it doesn't... when i open it in chrome in incognito, it also doesn't work...
– Andrej
Jul 4 '12 at 5:45
add a comment |
I can replicate your problem however it's not an Excel issue.
It is actually Godaddy that is redirecting you to the second link.
Try pasting that link into your browser and you will see it redirect to the second one.
Notes:Tested on Excel 2007, Firefox 13.0.1
1
hm.. but when I paste the link into the browser I stay on the first link.. that is why it's wierd.. how is godaddy able to detect the diference between pasting the link in the url or navigating from an excel file?
– Andrej
Jul 4 '12 at 5:27
They aren't, basically when your browser attempts to visit the first link, their server responds by sending you to the second. It has nothing to do with Excel. I've verified this on Chrome as well. I can't reproduce the circumstances you describe where you enter it on your browser and it doesn't redirect. What browser are you using?
– xlm
Jul 4 '12 at 5:31
i'm using Chrome, but I see what's going on now.. the request is session based.. so when i open from another browser, i can't see the link.. and somehow the session is broken when accessing from teh excel file..
– Andrej
Jul 4 '12 at 5:32
Try reproducing those circumstances again with Chrome, I'm quite sure you'll end up at the second link. Excel is just opening the link with your default browser. Also if this resolves your Q please mark it thanks!
– xlm
Jul 4 '12 at 5:34
1
sorry but it doesn't resolve the issue.. excel opens the link with chrome too, that's why it's wierd..when i paste that same link in chrome - it works.. but when i click on hyperlink it doesn't... when i open it in chrome in incognito, it also doesn't work...
– Andrej
Jul 4 '12 at 5:45
add a comment |
I can replicate your problem however it's not an Excel issue.
It is actually Godaddy that is redirecting you to the second link.
Try pasting that link into your browser and you will see it redirect to the second one.
Notes:Tested on Excel 2007, Firefox 13.0.1
I can replicate your problem however it's not an Excel issue.
It is actually Godaddy that is redirecting you to the second link.
Try pasting that link into your browser and you will see it redirect to the second one.
Notes:Tested on Excel 2007, Firefox 13.0.1
answered Jul 4 '12 at 5:25
xlm
1
hm.. but when I paste the link into the browser I stay on the first link.. that is why it's wierd.. how is godaddy able to detect the diference between pasting the link in the url or navigating from an excel file?
– Andrej
Jul 4 '12 at 5:27
They aren't, basically when your browser attempts to visit the first link, their server responds by sending you to the second. It has nothing to do with Excel. I've verified this on Chrome as well. I can't reproduce the circumstances you describe where you enter it on your browser and it doesn't redirect. What browser are you using?
– xlm
Jul 4 '12 at 5:31
i'm using Chrome, but I see what's going on now.. the request is session based.. so when i open from another browser, i can't see the link.. and somehow the session is broken when accessing from teh excel file..
– Andrej
Jul 4 '12 at 5:32
Try reproducing those circumstances again with Chrome, I'm quite sure you'll end up at the second link. Excel is just opening the link with your default browser. Also if this resolves your Q please mark it thanks!
– xlm
Jul 4 '12 at 5:34
1
sorry but it doesn't resolve the issue.. excel opens the link with chrome too, that's why it's wierd..when i paste that same link in chrome - it works.. but when i click on hyperlink it doesn't... when i open it in chrome in incognito, it also doesn't work...
– Andrej
Jul 4 '12 at 5:45
add a comment |
1
hm.. but when I paste the link into the browser I stay on the first link.. that is why it's wierd.. how is godaddy able to detect the diference between pasting the link in the url or navigating from an excel file?
– Andrej
Jul 4 '12 at 5:27
They aren't, basically when your browser attempts to visit the first link, their server responds by sending you to the second. It has nothing to do with Excel. I've verified this on Chrome as well. I can't reproduce the circumstances you describe where you enter it on your browser and it doesn't redirect. What browser are you using?
– xlm
Jul 4 '12 at 5:31
i'm using Chrome, but I see what's going on now.. the request is session based.. so when i open from another browser, i can't see the link.. and somehow the session is broken when accessing from teh excel file..
– Andrej
Jul 4 '12 at 5:32
Try reproducing those circumstances again with Chrome, I'm quite sure you'll end up at the second link. Excel is just opening the link with your default browser. Also if this resolves your Q please mark it thanks!
– xlm
Jul 4 '12 at 5:34
1
sorry but it doesn't resolve the issue.. excel opens the link with chrome too, that's why it's wierd..when i paste that same link in chrome - it works.. but when i click on hyperlink it doesn't... when i open it in chrome in incognito, it also doesn't work...
– Andrej
Jul 4 '12 at 5:45
1
1
hm.. but when I paste the link into the browser I stay on the first link.. that is why it's wierd.. how is godaddy able to detect the diference between pasting the link in the url or navigating from an excel file?
– Andrej
Jul 4 '12 at 5:27
hm.. but when I paste the link into the browser I stay on the first link.. that is why it's wierd.. how is godaddy able to detect the diference between pasting the link in the url or navigating from an excel file?
– Andrej
Jul 4 '12 at 5:27
They aren't, basically when your browser attempts to visit the first link, their server responds by sending you to the second. It has nothing to do with Excel. I've verified this on Chrome as well. I can't reproduce the circumstances you describe where you enter it on your browser and it doesn't redirect. What browser are you using?
– xlm
Jul 4 '12 at 5:31
They aren't, basically when your browser attempts to visit the first link, their server responds by sending you to the second. It has nothing to do with Excel. I've verified this on Chrome as well. I can't reproduce the circumstances you describe where you enter it on your browser and it doesn't redirect. What browser are you using?
– xlm
Jul 4 '12 at 5:31
i'm using Chrome, but I see what's going on now.. the request is session based.. so when i open from another browser, i can't see the link.. and somehow the session is broken when accessing from teh excel file..
– Andrej
Jul 4 '12 at 5:32
i'm using Chrome, but I see what's going on now.. the request is session based.. so when i open from another browser, i can't see the link.. and somehow the session is broken when accessing from teh excel file..
– Andrej
Jul 4 '12 at 5:32
Try reproducing those circumstances again with Chrome, I'm quite sure you'll end up at the second link. Excel is just opening the link with your default browser. Also if this resolves your Q please mark it thanks!
– xlm
Jul 4 '12 at 5:34
Try reproducing those circumstances again with Chrome, I'm quite sure you'll end up at the second link. Excel is just opening the link with your default browser. Also if this resolves your Q please mark it thanks!
– xlm
Jul 4 '12 at 5:34
1
1
sorry but it doesn't resolve the issue.. excel opens the link with chrome too, that's why it's wierd..when i paste that same link in chrome - it works.. but when i click on hyperlink it doesn't... when i open it in chrome in incognito, it also doesn't work...
– Andrej
Jul 4 '12 at 5:45
sorry but it doesn't resolve the issue.. excel opens the link with chrome too, that's why it's wierd..when i paste that same link in chrome - it works.. but when i click on hyperlink it doesn't... when i open it in chrome in incognito, it also doesn't work...
– Andrej
Jul 4 '12 at 5:45
add a comment |
I had the same problem only the site I was going to included processing and retrieving data base on a date stamp.
I would copy the url to a new cell.
change the date.
click on the new url, BUT get the old url.
However, if I ctl clicked on the new url cell,
go up to the cell display window
click my cursor anywhere in that window
then click on a different cell
the url date values change
and clicking on the url gets me the right data.
All this in IE.
It appears that when you copy the url it brings the url site info with it.
Not sure what magic happens when I open the cell and don't alter it, but it changes the url when you put your pointer over it.
I'm a regular magnet for this kind of stuff in Excel. Probably why I don't trust it.
add a comment |
I had the same problem only the site I was going to included processing and retrieving data base on a date stamp.
I would copy the url to a new cell.
change the date.
click on the new url, BUT get the old url.
However, if I ctl clicked on the new url cell,
go up to the cell display window
click my cursor anywhere in that window
then click on a different cell
the url date values change
and clicking on the url gets me the right data.
All this in IE.
It appears that when you copy the url it brings the url site info with it.
Not sure what magic happens when I open the cell and don't alter it, but it changes the url when you put your pointer over it.
I'm a regular magnet for this kind of stuff in Excel. Probably why I don't trust it.
add a comment |
I had the same problem only the site I was going to included processing and retrieving data base on a date stamp.
I would copy the url to a new cell.
change the date.
click on the new url, BUT get the old url.
However, if I ctl clicked on the new url cell,
go up to the cell display window
click my cursor anywhere in that window
then click on a different cell
the url date values change
and clicking on the url gets me the right data.
All this in IE.
It appears that when you copy the url it brings the url site info with it.
Not sure what magic happens when I open the cell and don't alter it, but it changes the url when you put your pointer over it.
I'm a regular magnet for this kind of stuff in Excel. Probably why I don't trust it.
I had the same problem only the site I was going to included processing and retrieving data base on a date stamp.
I would copy the url to a new cell.
change the date.
click on the new url, BUT get the old url.
However, if I ctl clicked on the new url cell,
go up to the cell display window
click my cursor anywhere in that window
then click on a different cell
the url date values change
and clicking on the url gets me the right data.
All this in IE.
It appears that when you copy the url it brings the url site info with it.
Not sure what magic happens when I open the cell and don't alter it, but it changes the url when you put your pointer over it.
I'm a regular magnet for this kind of stuff in Excel. Probably why I don't trust it.
answered Mar 17 '14 at 22:01
Dan
1
1
add a comment |
add a comment |
I found this problem crops up when the target URL is a secure site that required a login. Even though I am logged in already in a different window, it will not work properly. If I cut and paste the URL in a new tab or window, Chrome is smart enough to find that I have already authenticated and opens the new page properly. However, If I’m not logged in to the site, I will get redirected to the login page, as expected.
But when clicking the exact same URL in Excel, with the same conditions, I either get the login page only, or my remote site just tells me it is an unsupported browser.
The problem is clearly coming from Excel, because if I take that exact spreadsheet, save it as a PDF, the hyperlinks that display in the PDF work perfectly fine when clicked.
Other than fixing this obviously unintended “feature” of Excel/Office trying to verify links as others have posted, the only workaround that I found was to create a local redirect page which could take my unique parameters within the URL and open a new window as follows (thanks to others for the JavaScript code)
Redirect by changing the excel hyperlink to something like
http://mylocaldomain.com/redirect.html?ID=12345,
where the redirect page is on a local server you control and the parameter 12345 makes the URL redirect to the particular entry needed. For my SS with about 10000 links this works just fine.
Redirect.html is as follows.
<!DOCTYPE html>
<html>
<script>
function getUrlVars() {
var vars = {};
var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi,
function(m,key,value) {
vars[key] = value;
});
return vars;
}
document.getElementById("demo").innerHTML=getUrlVars()["type"];
var varbaseurl=[put your base url here]
window.location = varbaseURL + getUrlVars()["type"]
</script>
<body>
redirecting to: <p id=demo></p>
add a comment |
I found this problem crops up when the target URL is a secure site that required a login. Even though I am logged in already in a different window, it will not work properly. If I cut and paste the URL in a new tab or window, Chrome is smart enough to find that I have already authenticated and opens the new page properly. However, If I’m not logged in to the site, I will get redirected to the login page, as expected.
But when clicking the exact same URL in Excel, with the same conditions, I either get the login page only, or my remote site just tells me it is an unsupported browser.
The problem is clearly coming from Excel, because if I take that exact spreadsheet, save it as a PDF, the hyperlinks that display in the PDF work perfectly fine when clicked.
Other than fixing this obviously unintended “feature” of Excel/Office trying to verify links as others have posted, the only workaround that I found was to create a local redirect page which could take my unique parameters within the URL and open a new window as follows (thanks to others for the JavaScript code)
Redirect by changing the excel hyperlink to something like
http://mylocaldomain.com/redirect.html?ID=12345,
where the redirect page is on a local server you control and the parameter 12345 makes the URL redirect to the particular entry needed. For my SS with about 10000 links this works just fine.
Redirect.html is as follows.
<!DOCTYPE html>
<html>
<script>
function getUrlVars() {
var vars = {};
var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi,
function(m,key,value) {
vars[key] = value;
});
return vars;
}
document.getElementById("demo").innerHTML=getUrlVars()["type"];
var varbaseurl=[put your base url here]
window.location = varbaseURL + getUrlVars()["type"]
</script>
<body>
redirecting to: <p id=demo></p>
add a comment |
I found this problem crops up when the target URL is a secure site that required a login. Even though I am logged in already in a different window, it will not work properly. If I cut and paste the URL in a new tab or window, Chrome is smart enough to find that I have already authenticated and opens the new page properly. However, If I’m not logged in to the site, I will get redirected to the login page, as expected.
But when clicking the exact same URL in Excel, with the same conditions, I either get the login page only, or my remote site just tells me it is an unsupported browser.
The problem is clearly coming from Excel, because if I take that exact spreadsheet, save it as a PDF, the hyperlinks that display in the PDF work perfectly fine when clicked.
Other than fixing this obviously unintended “feature” of Excel/Office trying to verify links as others have posted, the only workaround that I found was to create a local redirect page which could take my unique parameters within the URL and open a new window as follows (thanks to others for the JavaScript code)
Redirect by changing the excel hyperlink to something like
http://mylocaldomain.com/redirect.html?ID=12345,
where the redirect page is on a local server you control and the parameter 12345 makes the URL redirect to the particular entry needed. For my SS with about 10000 links this works just fine.
Redirect.html is as follows.
<!DOCTYPE html>
<html>
<script>
function getUrlVars() {
var vars = {};
var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi,
function(m,key,value) {
vars[key] = value;
});
return vars;
}
document.getElementById("demo").innerHTML=getUrlVars()["type"];
var varbaseurl=[put your base url here]
window.location = varbaseURL + getUrlVars()["type"]
</script>
<body>
redirecting to: <p id=demo></p>
I found this problem crops up when the target URL is a secure site that required a login. Even though I am logged in already in a different window, it will not work properly. If I cut and paste the URL in a new tab or window, Chrome is smart enough to find that I have already authenticated and opens the new page properly. However, If I’m not logged in to the site, I will get redirected to the login page, as expected.
But when clicking the exact same URL in Excel, with the same conditions, I either get the login page only, or my remote site just tells me it is an unsupported browser.
The problem is clearly coming from Excel, because if I take that exact spreadsheet, save it as a PDF, the hyperlinks that display in the PDF work perfectly fine when clicked.
Other than fixing this obviously unintended “feature” of Excel/Office trying to verify links as others have posted, the only workaround that I found was to create a local redirect page which could take my unique parameters within the URL and open a new window as follows (thanks to others for the JavaScript code)
Redirect by changing the excel hyperlink to something like
http://mylocaldomain.com/redirect.html?ID=12345,
where the redirect page is on a local server you control and the parameter 12345 makes the URL redirect to the particular entry needed. For my SS with about 10000 links this works just fine.
Redirect.html is as follows.
<!DOCTYPE html>
<html>
<script>
function getUrlVars() {
var vars = {};
var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi,
function(m,key,value) {
vars[key] = value;
});
return vars;
}
document.getElementById("demo").innerHTML=getUrlVars()["type"];
var varbaseurl=[put your base url here]
window.location = varbaseURL + getUrlVars()["type"]
</script>
<body>
redirecting to: <p id=demo></p>
edited Nov 10 '14 at 19:43
Jawa
3,14982435
3,14982435
answered Nov 10 '14 at 19:33
JWalter
1
1
add a comment |
add a comment |
I solved this by doing a google search on the Url and using the google results page url for the hyperlink
e.g. for sweettoothrewards.com
I used https://www.google.ca/?gfe_rd=cr&ei=xwK5VY-LG8KC8QeGn4LoDw&gws_rd=ssl#q=+sweettoothrewards.com In opera browser with me not signed in.
add a comment |
I solved this by doing a google search on the Url and using the google results page url for the hyperlink
e.g. for sweettoothrewards.com
I used https://www.google.ca/?gfe_rd=cr&ei=xwK5VY-LG8KC8QeGn4LoDw&gws_rd=ssl#q=+sweettoothrewards.com In opera browser with me not signed in.
add a comment |
I solved this by doing a google search on the Url and using the google results page url for the hyperlink
e.g. for sweettoothrewards.com
I used https://www.google.ca/?gfe_rd=cr&ei=xwK5VY-LG8KC8QeGn4LoDw&gws_rd=ssl#q=+sweettoothrewards.com In opera browser with me not signed in.
I solved this by doing a google search on the Url and using the google results page url for the hyperlink
e.g. for sweettoothrewards.com
I used https://www.google.ca/?gfe_rd=cr&ei=xwK5VY-LG8KC8QeGn4LoDw&gws_rd=ssl#q=+sweettoothrewards.com In opera browser with me not signed in.
answered Jul 29 '15 at 16:50
mike s
1
1
add a comment |
add a comment |
I was able to investigate this further as I was trying to get an Excel workbook to link to my own web server. I noticed that clicking a link in Excel produced three queries to the server.
- GET HEAD (with temporary session)
- GET (with temporary session)
- GET (with real session)
But if the linked page was redirecting the user I didn't see the third GET. Instead the second GET was redirected to a new page and the session remained temporary. Which means that if the target page requires authentication the user will be redirected to a login page even if he actually is already authenticated.
This lead me to an idea to create a landing page that redirects the user to the target page if the user is authenticated. And it works. When the third GET is received the server notices that the user is authenticated and redirects to the target page. For unauthenticated user the landing page shows a link to the target page. And when the user clicks the link the user will be redirected to sign in page.
add a comment |
I was able to investigate this further as I was trying to get an Excel workbook to link to my own web server. I noticed that clicking a link in Excel produced three queries to the server.
- GET HEAD (with temporary session)
- GET (with temporary session)
- GET (with real session)
But if the linked page was redirecting the user I didn't see the third GET. Instead the second GET was redirected to a new page and the session remained temporary. Which means that if the target page requires authentication the user will be redirected to a login page even if he actually is already authenticated.
This lead me to an idea to create a landing page that redirects the user to the target page if the user is authenticated. And it works. When the third GET is received the server notices that the user is authenticated and redirects to the target page. For unauthenticated user the landing page shows a link to the target page. And when the user clicks the link the user will be redirected to sign in page.
add a comment |
I was able to investigate this further as I was trying to get an Excel workbook to link to my own web server. I noticed that clicking a link in Excel produced three queries to the server.
- GET HEAD (with temporary session)
- GET (with temporary session)
- GET (with real session)
But if the linked page was redirecting the user I didn't see the third GET. Instead the second GET was redirected to a new page and the session remained temporary. Which means that if the target page requires authentication the user will be redirected to a login page even if he actually is already authenticated.
This lead me to an idea to create a landing page that redirects the user to the target page if the user is authenticated. And it works. When the third GET is received the server notices that the user is authenticated and redirects to the target page. For unauthenticated user the landing page shows a link to the target page. And when the user clicks the link the user will be redirected to sign in page.
I was able to investigate this further as I was trying to get an Excel workbook to link to my own web server. I noticed that clicking a link in Excel produced three queries to the server.
- GET HEAD (with temporary session)
- GET (with temporary session)
- GET (with real session)
But if the linked page was redirecting the user I didn't see the third GET. Instead the second GET was redirected to a new page and the session remained temporary. Which means that if the target page requires authentication the user will be redirected to a login page even if he actually is already authenticated.
This lead me to an idea to create a landing page that redirects the user to the target page if the user is authenticated. And it works. When the third GET is received the server notices that the user is authenticated and redirects to the target page. For unauthenticated user the landing page shows a link to the target page. And when the user clicks the link the user will be redirected to sign in page.
answered Sep 9 '15 at 5:27
Mika
15316
15316
add a comment |
add a comment |
We manage to reproduce the problem and our developer findings indicate when you paste a link into Microsoft Excel, Excel prefaces the link with a byte order mark (BOM). When this link is loaded in the browser, it does not remove the BOM from the URL.
Upon loading the URL, the browser does several tests verify that the connection is secure (https) and this is failing due to the errant BOM. This ultimately causes the relay state error, since that parameter must be sent over a secure channel.
You can reproduce this problem by copying the cell and pasting it directly into firefox, thereby taking Excel out of the picture. This also fails (sometimes in a slightly different way) but suffers from the same root problem. If you remove the "https" from the pasted URL and simply retype it, you will notice that the link now works correctly.
This is a limitation in the fact that Excel stores the BOM in the URL, and the way in which the browser cannot interpret the BOM.
At the moment the only workaround we could think of is copy the URL link and paste it over to the browser and access the page.
Also, I would personally suggest you to raise a support ticket with Microsoft and I believe they might have better understanding on this issue to help you on this matter.
add a comment |
We manage to reproduce the problem and our developer findings indicate when you paste a link into Microsoft Excel, Excel prefaces the link with a byte order mark (BOM). When this link is loaded in the browser, it does not remove the BOM from the URL.
Upon loading the URL, the browser does several tests verify that the connection is secure (https) and this is failing due to the errant BOM. This ultimately causes the relay state error, since that parameter must be sent over a secure channel.
You can reproduce this problem by copying the cell and pasting it directly into firefox, thereby taking Excel out of the picture. This also fails (sometimes in a slightly different way) but suffers from the same root problem. If you remove the "https" from the pasted URL and simply retype it, you will notice that the link now works correctly.
This is a limitation in the fact that Excel stores the BOM in the URL, and the way in which the browser cannot interpret the BOM.
At the moment the only workaround we could think of is copy the URL link and paste it over to the browser and access the page.
Also, I would personally suggest you to raise a support ticket with Microsoft and I believe they might have better understanding on this issue to help you on this matter.
add a comment |
We manage to reproduce the problem and our developer findings indicate when you paste a link into Microsoft Excel, Excel prefaces the link with a byte order mark (BOM). When this link is loaded in the browser, it does not remove the BOM from the URL.
Upon loading the URL, the browser does several tests verify that the connection is secure (https) and this is failing due to the errant BOM. This ultimately causes the relay state error, since that parameter must be sent over a secure channel.
You can reproduce this problem by copying the cell and pasting it directly into firefox, thereby taking Excel out of the picture. This also fails (sometimes in a slightly different way) but suffers from the same root problem. If you remove the "https" from the pasted URL and simply retype it, you will notice that the link now works correctly.
This is a limitation in the fact that Excel stores the BOM in the URL, and the way in which the browser cannot interpret the BOM.
At the moment the only workaround we could think of is copy the URL link and paste it over to the browser and access the page.
Also, I would personally suggest you to raise a support ticket with Microsoft and I believe they might have better understanding on this issue to help you on this matter.
We manage to reproduce the problem and our developer findings indicate when you paste a link into Microsoft Excel, Excel prefaces the link with a byte order mark (BOM). When this link is loaded in the browser, it does not remove the BOM from the URL.
Upon loading the URL, the browser does several tests verify that the connection is secure (https) and this is failing due to the errant BOM. This ultimately causes the relay state error, since that parameter must be sent over a secure channel.
You can reproduce this problem by copying the cell and pasting it directly into firefox, thereby taking Excel out of the picture. This also fails (sometimes in a slightly different way) but suffers from the same root problem. If you remove the "https" from the pasted URL and simply retype it, you will notice that the link now works correctly.
This is a limitation in the fact that Excel stores the BOM in the URL, and the way in which the browser cannot interpret the BOM.
At the moment the only workaround we could think of is copy the URL link and paste it over to the browser and access the page.
Also, I would personally suggest you to raise a support ticket with Microsoft and I believe they might have better understanding on this issue to help you on this matter.
edited Jul 9 '15 at 5:30
Des Horsley
204112
204112
answered Oct 29 '14 at 5:40
Adolfo Guzman Jr.
1
1
add a comment |
add a comment |
To solve this issue on some sites I just create an HTML file that redirects to the site in question, and then point the hyperlink in Excel to this file and it works great..
sample:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0; URL=https://citiretailservices.citibankonline.com/RSnextgen/svc/launch/index.action?siteId=PLCN_GOODYEAR&langId=en_US#signon">
</HEAD>
<BODY>
Custom Redirect by Jason...
</BODY>
</HTML>
add a comment |
To solve this issue on some sites I just create an HTML file that redirects to the site in question, and then point the hyperlink in Excel to this file and it works great..
sample:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0; URL=https://citiretailservices.citibankonline.com/RSnextgen/svc/launch/index.action?siteId=PLCN_GOODYEAR&langId=en_US#signon">
</HEAD>
<BODY>
Custom Redirect by Jason...
</BODY>
</HTML>
add a comment |
To solve this issue on some sites I just create an HTML file that redirects to the site in question, and then point the hyperlink in Excel to this file and it works great..
sample:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0; URL=https://citiretailservices.citibankonline.com/RSnextgen/svc/launch/index.action?siteId=PLCN_GOODYEAR&langId=en_US#signon">
</HEAD>
<BODY>
Custom Redirect by Jason...
</BODY>
</HTML>
To solve this issue on some sites I just create an HTML file that redirects to the site in question, and then point the hyperlink in Excel to this file and it works great..
sample:
<HTML>
<HEAD>
<TITLE>Redirect</TITLE>
<META HTTP-EQUIV="refresh" CONTENT="0; URL=https://citiretailservices.citibankonline.com/RSnextgen/svc/launch/index.action?siteId=PLCN_GOODYEAR&langId=en_US#signon">
</HEAD>
<BODY>
Custom Redirect by Jason...
</BODY>
</HTML>
answered Aug 9 '17 at 2:57
Jason
1
1
add a comment |
add a comment |
I recently had this issue where a hyperlink function in Excel pointed to a redirect 301 in a WordPress site. I updated the 301 to point to a new document but the link in Excel continued to bring up the old document. I was only able to resolve this by clearing the document cache in IE, even though I am running Excel 2016 on a Windows 10 machine. Hope this helps.
add a comment |
I recently had this issue where a hyperlink function in Excel pointed to a redirect 301 in a WordPress site. I updated the 301 to point to a new document but the link in Excel continued to bring up the old document. I was only able to resolve this by clearing the document cache in IE, even though I am running Excel 2016 on a Windows 10 machine. Hope this helps.
add a comment |
I recently had this issue where a hyperlink function in Excel pointed to a redirect 301 in a WordPress site. I updated the 301 to point to a new document but the link in Excel continued to bring up the old document. I was only able to resolve this by clearing the document cache in IE, even though I am running Excel 2016 on a Windows 10 machine. Hope this helps.
I recently had this issue where a hyperlink function in Excel pointed to a redirect 301 in a WordPress site. I updated the 301 to point to a new document but the link in Excel continued to bring up the old document. I was only able to resolve this by clearing the document cache in IE, even though I am running Excel 2016 on a Windows 10 machine. Hope this helps.
answered Jan 24 at 16:14
Mark
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f444984%2fexcel-hyperlink-not-redirecting-properly-bug%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
I ran into the same problem with a URL that requires authentication. If you click from an Excel spreadsheet to a URL that requires you to be logged in to a cookie-based session, most sites will redirect the Microsoft Discovery Agent to a login page. Unless the site is smart enough to redirect the login page request back to the original request in the case that the user is already logged in, you end up being forced to log in manually once the page loads in your real browser. The user experience is that all links appear to be logged-out.
– Joe
Jul 10 '13 at 4:43