Maintaining hyperlinks when I move Excel files to another location

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 go in
and change the hyperlink address in each file after they are moved?

Thanks for the advice.
 
×

מיכ×ל (מיקי) ×בידן

I assume you could use a formula which combines 2 functions:
SUBSTITUTE and HYPERLINK.
It is not easy to present a dedicated solution without seeing the previous
and requested Hyperlink.
Try to response with 2-3 examples.
Micky
 

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