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