Fix Power Query Auto Refresh Pausing in Shared Excel Workbooks
Question details
The user needs to automatically refresh Power Query data in an Excel workbook shared across multiple users without manual interaction.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Co-authoring a shared Excel workbook hosted on Microsoft Teams or SharePoint with active Power Query data connections.
- Observed behavior
- Automatic refresh functionality pauses when multiple users have the file open. Automated solutions like Power Automate or Excel for the web fail to refresh external data sources successfully.
Ensure you have edit permissions for the shared workbook and verify that your external data sources are accessible from your current network connection.
Perform a Manual Data Refresh
Since automatic background refresh pauses during co-authoring to prevent conflicts, manually refreshing the workbook is the most reliable workaround.
When an Excel file is hosted on SharePoint or Teams and multiple users have it open, Excel suspends automated zero-click background refreshes. Relying on the manual refresh function ensures the data updates correctly without breaking the co-authoring session.
With your shared workbook open in the Excel desktop application, click on the 'Data' tab located in the top ribbon.
Click the 'Refresh All' button. This will successfully ping your external data sources and update the queries, even with multiple users in the workbook.

Submit a Microsoft 365 Service Request
If your shared workbook relies on OneDrive for Business, reaching out to Microsoft Support can help identify tenant-specific limitations.
Avoid Unsupported Automation Methods
Understand the limitations of using Power Automate or macros for refreshing shared workbooks.
Try WPS Office for Seamless Data Management
Dealing with Microsoft Excel's strict co-authoring limitations and Power Query constraints can disrupt your workflow. WPS Office provides a lightweight, fast, and free alternative with excellent spreadsheet features, making it easy to manage your data files without heavy resource demands.
- 1. Download and Install: Visit the official WPS Office website to download the free suite and follow the simple installation instructions.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx documents. All your formatting and data will be perfectly preserved.

Frequently Asked Questions
Why does Power Query automatic refresh pause in shared workbooks?
Excel intentionally pauses automatic background refreshes when multiple users are co-authoring a file in Teams or SharePoint. This is a built-in behavior designed to prevent data synchronization conflicts and corruption during active collaboration.
Can I use Power Automate to refresh Excel data in SharePoint without user interaction?
While Power Automate features an Excel connector, it currently struggles to trigger external Power Query data source refreshes successfully in co-authored environments. It is not a reliable workaround for zero-click refreshing in this scenario.
Will saving the file as an XLSM to use VBA macros fix the auto-refresh issue?
Using VBA macros (.xlsm) is not recommended for this problem. XLSM files frequently conflict with web-based co-authoring features and can cause broader integration issues with other Power Platform services.




