Hyperling changing

[Guest]

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

 

[David Biddulph]

%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?

 

[Guest]

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]

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

 

[Guest]

Don't use:
Insert > Hyperlink...
instead something like:

=HYPERLINK("file:///c:\Documents and Settings\Book1.xls","book1")

 

[Guest]

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

 

[Guest]

Gary's Student,
I have been reading up on the corruption issues
from the hyperlink 'insert", and have tried the formula which I didn't
realize existed. It seems to be working. Is there an acknowledged bug with
the hyperlink insert?

Thanks,
Mike

 

[Elkay]

I get this whenever I upload anything the intranet at work. It is
replacing the spaces in your path/filename with the %20. The link
continues to work - just looks strange!

 

[David Biddulph]

Which version of Excel are you using?

I'm using Excel 2003, and a hyperlink works just as well for me when it has
the %20 in the link as it did with the spaces. I'm intrigued as to why your
Excel should behave differently.

 

[Guest]

Excel 2003

Which version of Excel are you using?

I'm using Excel 2003, and a hyperlink works just as well for me when it has
the %20 in the link as it did with the spaces. I'm intrigued as to why your
Excel should behave differently.

 

[David Biddulph]

Interesting. Perhaps someone else can tell us whether they have seen the
same problem as yours, and if so what are the circumstances in which it
happens?