Does anyone know how to capture when links are updated within Excel?
E.g. Book1.xls contains a link to a cell in book2.xls when book1 is opened
and the usual 'this workbook contains links do other data sources' and the
'Update' button is selected. We wish to capture information on when this link
was updated and what the previous value was thus creating a history of the
workbook.
I know how to program an xls file to bypass the autoupdate on open and
create some code that prompts an alternative similar message box but this
doesn't prevent someone using 'links' on the menus. I suppose I should say is
there an API that I can use to capture when this event occurs. Any help would
be very welcome