Brett,

How are you entering your hyperlinks?

In XL, there is a HYPERLINK() function where you would create a formula to
create you hyperlinks. If you know how to concatenate, you could use this
function to create a formula the will return a hyperlink in the cell.

Be sure to look up HYPERLINK() in XL's Help, it is a little tricky to use.

HTH,

Conan




"Brett" wrote in message
...
Hello.

I'm trying to create links within one workbook to several hundred others.
I'd like to use the TEXT formula in my cell references (about 10 per
workbook) so that I can simply copy all of my workbook names to update the
cell references instead of using the REPLACE function on all of my links.

Basically I will be using a cell value as part of the name of a linked
workbook.

For example:

In Workbook_A:

Workbook_1 Link1 Link2 Link3 Link4 Link5
Workbook_2 Link1 Link2 Link3 Link4 Link5
...
Workbook_400 Link1 Link2 Link3 Link4 Link5