I have 2 workbooks. Workbook A has links to workbook B.

The same field in workbook A is frequently updated. Is it possible to link
to a new cell in workbook B each time the field in workbook A is updated? Or
does the Link have to override the data in workbook B?

Thanks for your help!

TW

You want to update a value in either workbook and have the other workbook get
the same update?

If you use formulas, this would cause a circular reference.

Kind of like putting =a1 in B1 and =b1 in A1.

On top of that, if you type in the value, then the formula will be replaced with
the link.

Terence wrote:

I have 2 workbooks. Workbook A has links to workbook B.

The same field in workbook A is frequently updated. Is it possible to link
to a new cell in workbook B each time the field in workbook A is updated? Or
does the Link have to override the data in workbook B?

Thanks for your help!

TW

--

Dave Peterson

On top of that, if you type in the value, then the VALUE will REPLACE the LINK.

(sorry)

Terence wrote:

I have 2 workbooks. Workbook A has links to workbook B.

The same field in workbook A is frequently updated. Is it possible to link
to a new cell in workbook B each time the field in workbook A is updated? Or
does the Link have to override the data in workbook B?

Thanks for your help!

TW

--

Dave Peterson