Hyperlink problem:twice the amount

[Robb]

When I insert a hyperlink in Excel, the link changes when I reopen Excel the next time.

i.e. if I add the hyperlink..

"redirect.cgi?redirect=file_name"

it gets changed to:

"C:\mainfolder\subfolder\redirect.cgi"

Any ideas why it does this?

If I add an actual URL to the hyperlink, it doesn't get changed.

i.e. "http://www.mysite.com/redirect.cgi?redirect=file_name"

[oldchippy]

Have a look at this link. May be it's because its looking for the shortest path ie. your PC

http://en.wikipedia.org/wiki/URL