View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alireza Nejad[_2_] Alireza Nejad[_2_] is offline
external usenet poster
 
Posts: 6
Default Copy and paste the hyperlinks

When hyperlinking a file in excel I use \\Server/folder/folder/file.xxx or
\\Server\folder\folder\file.xxx however when the file is saved the link
changes to ../../folder/folder/file.xxx the problem comes when I either copy
the cell with the hyperlink or copy the file the hyperlink will no longer
work gives error €œThe address of this site is not valid. Check the address
and try again.€ Any suggestions as how to maintain the hyperlink integrity?
Thank you for any suggestions.