update the hyperlink in file after changing the file name
 

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.

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

update the hyperlink in file after changing the file name
 

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

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




"Bel71" wrote in message
...
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.

update the hyperlink in file after changing the file name
 

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.



"Matt.Russett" wrote in message
...
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. :(