| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. :( |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. :( |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to pull data from another file - update name of file | Excel Discussion (Misc queries) | |||
| delete info from source file w/out changing the destination file | New Users to Excel | |||
| why is absolute hyperlink in XLS file changed when file is saved | Excel Discussion (Misc queries) | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
| Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) | |||
Hybrid Mode
