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.

How are you referencing Todd back to the MasterSheet

Is it in your VBA code

or

is it via formulas in Todd "A1:a10"

eg ='D:\My Documents\[MasterSheet.xls]Sheet1'!$A$

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

I am using formulas.


-----Original Message-----

How are you referencing Todd back to the MasterSheet

Is it in your VBA code

or

is it via formulas in Todd "A1:a10"

eg ='D:\My Documents\[MasterSheet.xls]Sheet1'!$A$1


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.

Unfortunalty I do not know why Excel only links back to the Mastersheet
when Todd is opened or the formula is changed and does not link back
when Todd recalculates


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

One guess.

In masterfile, don't format the cell as text.

--
Regards,
Tom Ogilvy

"Todd Huttenstine" wrote in message
...
I am using formulas.


-----Original Message-----

How are you referencing Todd back to the MasterSheet

Is it in your VBA code

or

is it via formulas in Todd "A1:a10"

eg ='D:\My Documents\[MasterSheet.xls]Sheet1'!$A$1


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.