It seems that the behavior you're experiencing, where changes in the SharePoint list only reflect in the Excel document after it is saved, may be related to how the Excel Online (Business) connector operates within Power Automate. Unfortunately, real-time updates may not be fully supported due to the way Excel Online handles data changes and saves.

To improve the responsiveness of your flow, ensure that your flow is set up to trigger on the correct events and that it is configured properly.