Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
%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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
Don't use:
Insert Hyperlink... instead something like: =HYPERLINK("file:///c:\Documents and Settings\Book1.xls","book1") -- Gary''s Student - gsnu200748 "Mike K" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
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 "Gary''s Student" wrote: Don't use: Insert Hyperlink... instead something like: =HYPERLINK("file:///c:\Documents and Settings\Book1.xls","book1") -- Gary''s Student - gsnu200748 "Mike K" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
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! On Oct 7, 9:35 am, Mike K wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
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 "Mike K" wrote in message ... 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
Excel 2003
"David Biddulph" wrote: 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 "Mike K" wrote in message ... 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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperling changing
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? -- David Biddulph "Mike K" wrote in message ... Excel 2003 "David Biddulph" wrote: 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 "Mike K" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel redirects hyperling to php site | Links and Linking in Excel | |||
Changing the TAB key | Excel Discussion (Misc queries) | |||
Changing Max | Excel Worksheet Functions | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) |