event after update external data

[Gespierde velopompe]

Hi all,

I have several pages that I use to retrieve external data into excel. The external data get updated after opening excel and then every five minutes.

Which vba code can I use to check wether the update(s) have finished so I can call on other events? If possible, can you provide me the code to check wether all updates have been processed and also to check if the update for a specific sheet has been updated.

I already checked a lot of code myself, but I don't seem to get this going.

Thanks in advance.