Maybe if you change the hyperlink base to C:\, then the link will keep its
correct name--instead of excel trying to shorten it.

ps. I like to use the =hyperlink() worksheet function. I've never seen excel
mess with those.


RWS wrote:

in a worksheet, how do i set the base address for hyperlinks? i hyperlink
hundreds of product photos to item numbers in my inventory worksheet. when
inserting hyperlinks i have to move up the directory numerous levels to get
to my vendors folder where i store the item photos. i have tried the process
microsoft recommends but it doesn't work.

--

Dave Peterson