Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintain hyperlink when moving excel files
I am using Office 2003. I have a folder with a large number of Excel files
that all have hyperlinks to unique Word documents saved in another area of the shared drive. I would like to move the entire folder but am afraid that the hyperlinks won't work correctly when the folder is moved. I tested a few of the Excel files and the hyperlinks did not work after the change in location. Is there a way I can move the entire folder of Excel files while keeping the active hyperlinks to the Word documents without having to change the hyperlink address in each file after they are moved? Here are some examples of the current hyperlinks address to the Word documents: .../Project%20Development/DCA%20Action%20Pkgs/FY%2003/OTI/FY03%20OTI%20action%20package_vFinal.doc .../../../Project%20Development/DCA%20Action%20Pkgs/FY%2006/Georgia/FY06%20DCA%20Action%20Package_Georgia_Constanta_vF INAL.doc Thanks for the advice. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintain hyperlink when moving excel files
In short... No. When you move the folder you will break the hyperlinks. You
could use VBA to open each file and modify the links but that will requre some custom code. There is no easy way around it... -- HTH... Jim Thomlinson "diestro" wrote: I am using Office 2003. I have a folder with a large number of Excel files that all have hyperlinks to unique Word documents saved in another area of the shared drive. I would like to move the entire folder but am afraid that the hyperlinks won't work correctly when the folder is moved. I tested a few of the Excel files and the hyperlinks did not work after the change in location. Is there a way I can move the entire folder of Excel files while keeping the active hyperlinks to the Word documents without having to change the hyperlink address in each file after they are moved? Here are some examples of the current hyperlinks address to the Word documents: ../Project%20Development/DCA%20Action%20Pkgs/FY%2003/OTI/FY03%20OTI%20action%20package_vFinal.doc ../../../Project%20Development/DCA%20Action%20Pkgs/FY%2006/Georgia/FY06%20DCA%20Action%20Package_Georgia_Constanta_vF INAL.doc Thanks for the advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zipping my Excel Files and maintain the folder structure | Excel Discussion (Misc queries) | |||
How do you maintain links when moving workbooks? | Excel Discussion (Misc queries) | |||
how to maintain hyperlink in excel to pdf conversion | New Users to Excel | |||
how to maintain hyperlink between worksheets after sorting | Excel Worksheet Functions | |||
How to maintain hyperlink when sorting data? | Excel Discussion (Misc queries) |