View Single Post
  #1   Report Post  
colerb
 
Posts: n/a
Default Why do long hyperlinks get truncated on save in Excel?

I am working with a database created in Excel. Included in that database is
a series of hyperlinks to pictures saved on a shared drive on network. When
the spreadsheet is run from a local computer the hyperlinks work fine, but
when it is saved on the network, the hyperlinks become truncated at the
begining, instead of:

k:\foldera\folderb\folderc\picture.jpg

I get:

...\..\..\folderc\picture.jpg

This happens on saving the spreadsheet on the network...