Maintain hyperlink when moving excel files


D

diestro

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_vFINAL.doc

Thanks for the advice.
 
Ad

Advertisements

J

Jim Thomlinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top