View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt.Russett Matt.Russett is offline
external usenet poster
 
Posts: 14
Default update the hyperlink in file after changing the file name

On May 10, 12:56*pm, Bel71 wrote:
I have received a template file which has hyperlinks from the summary page to
individual detail worksheets. When I am saving the file on my desktop the
hyperlinks are lost as they look for the original file. Is there any way to
auto update the links? I would really appreciate any help.


I am also curious about this one!! I have done projects for clients
where I had scenario summaries on each row followed by a link to a pdf
file which would display graphs and maps, etc. Even if I zip all the
PDFs up in the same folder with the excel workbook, after I send it
away all of the links are broken. :(