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