Track changes w/ two workbooks

[Scott A]

Is there a way to track changes in workbook A if workbook A references
information in workbook B.

For example, if workbook B, cell A1 has the name Jim and it is changed to
James, will workbook A, cell A1 (ref workbook B, cell A1) indicate that cell
A1 changed?

I appreciate any assistance.

 

[JBeaucaire]

If by "will indicate" do you mean change to show the updated data, yes,
that's simple enough. It won't light up or anything.

In the second workbook, make sure your reference is dynamic, meaning it
looks into workbook1 itself for the information, and each time you open
workbook2 you allow it to update the linked data.

=[Book1.xls]Sheet1!A1