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...

I am having the same problem. Have you found a solution?

Cheers

Grant

"colerb" wrote:

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...