Check out the XL help file article "Set the base address for the hyperlinks
in a workbook" for a nice way to setup hyperlinks if you know you need to
change the base address.

The other way (and my personal preference) is to use the HYPERLINK formula.
Then you would be able to do a Find & Replace, or even use a little VB to get
the username of an individual and plug it into the formula.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Doug" wrote:

I currently have many hyperlinks to files that are in a single folder named
Training Cycles on my computer. If I want to transfer this to another
computer to be used also, how can I do this without changing all the file
extensions. For example, on one computer the file extention might be
"C:\Users\The King's\Documents\Training Cycles" and on another computer the
extension might be "C:\Users\John Doe's\Documents\Training Cycles". How can
I make this work?
--