Refresh lag in excel spreadsheet

I have an Excel spreadsheet on a Microsoft team that is updated by one user every few seconds for about 20 minutes. The user updates it by scanning a QR code, which then looks data and populates a specific page in the spreadsheet. 20 other users on the team are monitoring the spreadsheet and performing task based on what they see.

We are noticing that at times there is a significant lag Between data entry and actual update seen by the other users. This lag may be one to two minutes which is not acceptable in our used.

I realize there are lots of variables that could be affecting this lag, but I am looking for suggestions from the community on how to troubleshoot this. Does anyone have a better solution?