The %20 in a link is the code for a space, so that did not change anything.
I expect it remove the drive letter because it is the same as the workbook.
Perhaps you can change to using the Hyperlink Worksheet Function
instead of object links. Using the Hyperlink Worksheet Function the
links will not change nor will they adjust if you insert/delete rows/columns/cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Globe Director" wrote in message
...
From a worksheet (Excel Office 2003) on my computer I create a hyperlink to a
Word file on our server. All works fine until I save the worksheet, which
changes the hyperlink address, so it no longer functions. The changes are;
it removes the drive letter and adds %20 in front of each word in the
address. Can you help?