H
Help007
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
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