Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink problem with percents
This seems to only happen with Excel 2003 and XP
Lets say I have a file such as: C:\Group A\[1]Movie.mpg and this link should work When I go to edit this link this is what it provides: Group%20A/%5b1%5dMovie.mpg This link does not work Notice that the Slashes switch Also that %20 is a space %5b is [ and %5d is ] When you move your cursor over the link and look at its path it shows Group A/%5b1%5dMovie.mpg Apparently %20 works and gives the space, and it does when i use links to files without [ or ] So therefore the problem lies with [ and ] and that %5b and %5d are not doing their job. How can I go about fixing this problem, and yes the file must contain [ and ] in them. |
#2
|
|||
|
|||
It is for this reason I never uses spaces in file names!
You are correct - in hyperlinks a space become %20 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MLange2064" wrote in message ... This seems to only happen with Excel 2003 and XP Lets say I have a file such as: C:\Group A\[1]Movie.mpg and this link should work When I go to edit this link this is what it provides: Group%20A/%5b1%5dMovie.mpg This link does not work Notice that the Slashes switch Also that %20 is a space %5b is [ and %5d is ] When you move your cursor over the link and look at its path it shows Group A/%5b1%5dMovie.mpg Apparently %20 works and gives the space, and it does when i use links to files without [ or ] So therefore the problem lies with [ and ] and that %5b and %5d are not doing their job. How can I go about fixing this problem, and yes the file must contain [ and ] in them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink Problem | Excel Discussion (Misc queries) | |||
Problem with hyperlink to .pdf file....please help. | Excel Discussion (Misc queries) | |||
Problem with hyperlink | Excel Discussion (Misc queries) | |||
Excel 2003 hyperlink problem | Links and Linking in Excel | |||
Hyperlink to word document problem | Links and Linking in Excel |