View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Help007 Help007 is offline
external usenet poster
 
Posts: 1
Default 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