Tracking changes that occur when links have been updated
 

Hi,

I understand the tracking functionality within Excel, however unfortunately
it does not track any changes that occurs due to data in a linked spreadsheet
being updated.

For example Sheet B is linked to Sheet A. Changes are made in Sheet A, which
are updated when I open Sheet B. When I attempt to highlight these changes,
none are found.

Is there a macro which can get around this?

Thanks