One way is to link one (or more) cell(s) to your data table, and use an equal number of cells to store values as a check. Then use the worksheet's calculate event to compare the linked value to the stored value. This example is for a link in cell A1, using A2 to store the comparison value, and your macro is named MacroToTrigger. Of course, if the external link has not changed, then the macro will not be triggered. In that case, you would need to use a macro that updates the external link and runs your macro.


1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed


Private Sub Worksheet_Calculate()

    If Range("A1").Value = Range("A2").Value Then Exit Sub
    
    Application.EnableEvents = False
    MacroToTrigger
    Range("A2").Value = Range("A1").Value
    Application.EnableEvents = True
End Sub