I have 2 workbooks. One workbook is called Todd. The
other workbook is called MasterFile. On sheet1, the cells
in range A1:A10 in workbook Todd references cells in range
A1:A10 on sheet1 of workbook MasterFile.

So whatever the value of the cells in range A1:A10 of
workbook Masterfile is, will be the exact same value of
the cells in range A1:A10 of workbook Todd.

Here is the problem, when workbook Todd references
Masterfile, it does not pick up on links. For example,
lets say I change or even create a link in cell A5 of
workbook Masterfile, because workbook Todd references
this, the value of cell A5 will show the words, but not
contain the link.

Is there anyway through VBA that I can get the workbook to
pick up on links?

Thank you.