View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default Hyperling changing

David,
No, it doesn't work at all. I have substituted a hyperlink
formula I found from a forum search from Mr Peterson. That seems to be
working. I will use it for a few days and see if it corrupts.

Thanks,
Mike

"David Biddulph" wrote:

But are you saying that with the %20 the link doesn't work?
--
David Biddulph

"Mike K" wrote in message
...
Its definitely there. I can change it back, click on the link and it
works.
But when I close the workbook and reopen, its reverted back to the %20.

Mike

"David Biddulph" wrote:

%20 is the code for a space.
Are you saying that the link now doesn't work? Are you sure that the
document is still there?
--
David Biddulph

"Mike K" wrote in message
...
Oh Wise Ones,
I have a weird problem that I have never
encountered before. I inserted a hyperlink and tested it, and it worked
fine.
I saved the workbook. When I the workbook again, the hyperlink was
altered
with % and numbers inserted. Needless to say the hyperlink was broken.
I
fix
it and it changes back. What is going on?

I entered this:
\My Documents\Rubloss Calculator.xls

and it turns into this:
/My%20Documents/Rubloss%20Calculator.xls

What can I do to prevent this?

Thanks,
Mike