Sorry I've been so long. I wrote up a long post and couldn't post it a few days ago. It kept giving me an error saying there was illegal SQL code or something like that. I even made a post about not being able to post to you. But I think with some help from the moderators, I figured it out. So here goes again..
This is a very difficult situation when you start involving API's that change values of a cell that changes the result of a formula, then have code that will run only when the formula cell changes. I don't think I, or anybody will be able to figure this out without actually having a sample workbook that works on their computer with whatever API's you are using. I don't know how your workbook is set up so I don't really know what to do to make this work. Every time I come up with a solution you add something I didn't know about.. which I'm not upset about that, I used to do it too many years ago when I was the one asking questions because I didn't think the details mattered and I'd figure it out.. lol.. but sometimes they do matter.

Just in case this works, you can try adding this line of code to the worksheet change event:
Target.Select

so you end up with this in that worksheet's module:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Select

End Sub

Whatever cell is the last cell to change will be selected though when any code runs that causes cells to change, whether you want it to or not..

Sorry I couldn't help more, but I don't know what else to do without having a sample workbook that I can work with. I'm not getting my hopes up, but let me know if that little fix works!