Power Query Problems

Fix Power Query Auto Refresh Pausing in Shared Excel Workbooks

Muhammad TalhaMuhammad Talha Nov 4, 2026 869 views

Question details

The user needs to automatically refresh Power Query data in an Excel workbook shared across multiple users without manual interaction.

Fixing Power Query Automatic Refresh in Shared Excel Workbooks
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.
Before you start

Ensure you have edit permissions for the shared workbook and verify that your external data sources are accessible from your current network connection.

Solution 1Recommended

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.

1
Open the Data Tab

With your shared workbook open in the Excel desktop application, click on the 'Data' tab located in the top ribbon.

2
Click Refresh All

Click the 'Refresh All' button. This will successfully ping your external data sources and update the queries, even with multiple users in the workbook.

Perform a Manual Data Refresh
Co-authoring Compatibility: The manual Refresh All command works seamlessly and synchronizes the updated data to all active users in the shared workbook.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website to download the free suite and follow the simple installation instructions.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx documents. All your formatting and data will be perfectly preserved.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Free and lightweight alternative to Microsoft OfficeFamiliar user interface requiring zero learning curveSmooth performance for handling large data sets
microsoft office alternative - wps office

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.