An electrical monitoring device has a hotlink to excel and continually
updates the data in a particular cell, we are trying to create a spreadsheet
that will record that output every 5 mins and paste it into a table.

I created a table to record the data and a macro that will identify when to
copy the data into the table.

Unfortunately the hotlink stops updating as soon as the macro starts
running, and we need them to run together. Is this possible?