update the hyperlink in file after changing the file name

[Bel71]

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.

 

[Matt.Russett]

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.

 

[Steve Dunn]

Instead of using Insert Hyperlink, use the HYPERLINK function, e.g.:

=HYPERLINK("Sheet2!A1", "Go to A1 on Sheet2")

 

[Steve Dunn]

Matt, yours is slightly different, still use the HYPERLINK function rather
than Insert Hyperlink, but remove paths from the filenames.

=HYPERLINK("example.pdf","Open Example PDF file")

will automatically look in the same folder as your workbook.

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.