Macro Issue Using Excel via SharePoint

Hello!

  Here's the issue as best as I can articulate it: we run an Excel spreadsheet from a central computer out to our six screens on our shop floor using SharePoint and opening to Excel. When someone makes edits to the sheet in Excel online, we see them live in the sheet that's already opened on each desktop, which is great. The only issue we have is that a macro is running a loop of an auto scroll and when information is updated in the workbook, it doesn't update on the sheet running the macro. I've added a refresh code into the loop, but that doesn't seem to do anything. Is there a way to have the macro run and still be able to update with the live edits without someone having to stop the macro?

Thanks!

Ryan