I'm trying to display the text of a hyperlink and have used many of the
methods described in this discussion group, but my links seem to have a
problem. When I right-click to "Edit Hyperlink", the link is displayed as
"..\..\Sales\Business Cases\NewProject.xls". The link works fine if you
click on it and the text displayed when you hover over the cell shows the
full path, but all of the methods to display the hyperlink show the
"...\...\". Anyone know how I can get the full path without this truncation?