Links to other worksheets on another workbook

[Todd Huttenstine]

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.

 

[mudraker]

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$

 

[Todd Huttenstine]

I am using formulas.

 

[mudraker]

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

 

[Tom Ogilvy]

One guess.

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

--
Regards,
Tom Ogilvy

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


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

.