Linking to RT from MS Excel

I’m trying to set up a link from a MS Excel spreadsheet to an RT ticket.
I’ve tried the “hyperlink” function and also a directl link; no matter
what I do RT only goes to the home page.

Hyperlinking directly to a ticket seems to work otherwise. Is there
something particular about excel that makes it break? Does anyone know
where to look?

If you have eight hours to chop down a tree
spend six sharpening your axe.
–Abraham Lincoln

I’m trying to set up a link from a MS Excel spreadsheet to an RT ticket.
I’ve tried the “hyperlink” function and also a directl link; no matter
what I do RT only goes to the home page.

Hyperlinking directly to a ticket seems to work otherwise. Is there
something particular about excel that makes it break? Does anyone know
where to look?

Here’s the apache logs of the exchange:

140.211.84.66 - - [04/May/2011:16:06:26 -0700] “GET
/Ticket/Display.html?id=9 HTTP/1.1” 302 439 “-” "Mozilla/4.0 (compatible;
MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR
3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDS; .NET4.0C;
InfoPath.2)"
140.211.84.66 - - [04/May/2011:16:06:28 -0700] “GET
/NoAuth/Login.html?next=e7071bf98bd712fceaa850abf5cc00e6 HTTP/1.1” 200
5559 “-” "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0;
SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media
Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)"
140.211.84.66 - - [04/May/2011:16:06:31 -0700] “GET
/Ticket/Display.html?id=9 HTTP/1.1” 302 439 “-” "Mozilla/4.0 (compatible;
MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR
3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDS; .NET4.0C;
InfoPath.2)"
140.211.84.66 - - [04/May/2011:16:06:32 -0700] “GET
/NoAuth/Login.html?next=f6e5ec0408aa263848c49978088df779 HTTP/1.1” 200
5559 “-” “Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0;
SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media
Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)“
140.211.84.66 - - [04/May/2011:16:06:35 -0700] “GET
/NoAuth/Login.html?next=f6e5ec0408aa263848c49978088df779 HTTP/1.1” 302 384
”-” “Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)“
140.211.84.66 - - [04/May/2011:16:06:36 -0700] “GET / HTTP/1.1” 200 38925
”-” “Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)”

Anyone have any clue what’s going on?

It looks like a failed login, but the user is logged in on the machine,
and RT opens up on the user’s dashboard.

This is repeatable on both my home server and on the Gossamer hosted
installation we have.

If you have eight hours to chop down a tree
spend six sharpening your axe.
–Abraham Lincoln

I’m trying to set up a link from a MS Excel spreadsheet to an RT ticket.
I’ve tried the “hyperlink” function and also a directl link; no matter
what I do RT only goes to the home page.

Hyperlinking directly to a ticket seems to work otherwise. Is there
something particular about excel that makes it break? Does anyone know
where to look?

Here’s the apache logs of the exchange:

Anyone have any clue what’s going on?

It looks like a failed login, but the user is logged in on the machine,
and RT opens up on the user’s dashboard.

I’ve encountered similar problems with other sort of websites if hyperlinked from Office (not necessarily Excel, but also Word and PowerPoint). It’s very irritating. I understand the issue is that Office programs will make an initial web request NOT using your favourite web browser, where it does not have the correct login credentials (or cookies of a pre-existing logged in session), and thus ends up with the wrong web content. If that initial web request results in a HTTP 403 error (forbidden), the Office program will just pop-up an error dialog without even launching the browser (this happens on my Drupal website).

I would love to know if there’s a solution to this too.

Regards,

.lzs

Install firefox and set it as your default browser, then check if the
problem get solved or not. I think I had experienced the same thing
before with ms IE

I’m trying to set up a link from a MS Excel spreadsheet to an RT ticket.
I’ve tried the “hyperlink” function and also a directl link; no matter
what I do RT only goes to the home page.

Hyperlinking directly to a ticket seems to work otherwise. Is there
something particular about excel that makes it break? Does anyone know
where to look?

Here’s the apache logs of the exchange:

140.211.84.66 - - [04/May/2011:16:06:26 -0700] “GET
/Ticket/Display.html?id=9 HTTP/1.1” 302 439 “-” "Mozilla/4.0 (compatible;
MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR
3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDS; .NET4.0C;
InfoPath.2)“
140.211.84.66 - - [04/May/2011:16:06:28 -0700] “GET
/NoAuth/Login.html?next=e7071bf98bd712fceaa850abf5cc00e6 HTTP/1.1” 200
5559 “-” “Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0;
SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media
Center PC 6.0; MDDS; .NET4.0C; InfoPath.2)”
)”

I’m trying to set up a link from a MS Excel spreadsheet to an RT
ticket.
I’ve tried the “hyperlink” function and also a directl link; no matter
what I do RT only goes to the home page.

Hyperlinking directly to a ticket seems to work otherwise. Is there
something particular about excel that makes it break? Does anyone know
where to look?

Here’s the apache logs of the exchange:

Anyone have any clue what’s going on?

It looks like a failed login, but the user is logged in on the machine,
and RT opens up on the user’s dashboard.

I’ve encountered similar problems with other sort of websites if
hyperlinked from Office (not necessarily Excel, but also Word and
PowerPoint). It’s very irritating. I understand the issue is that Office
programs will make an initial web request NOT using your favourite web
browser, where it does not have the correct login credentials (or cookies
of a pre-existing logged in session), and thus ends up with the wrong web
content. If that initial web request results in a HTTP 403 error
(forbidden), the Office program will just pop-up an error dialog without
even launching the browser (this happens on my Drupal website).

OK, for posterity, here’s the solution, provided by our very helpful IT
department:

This MSKB article http://support.microsoft.com/kb/899927 explains the
nature of the problem and which makes reference to the registry fix
described in this article http://support.microsoft.com/kb/218153.

I can vouch for the fact that applying the fix does resolve the link problem.

My daughter is racing a triathlon to raise money for her swim club. Want
to help?