How to Fix Excel SharePoint View Not Updating for Colleagues
Question details
Users need to allow colleagues to view and refresh a connected Excel file in SharePoint without giving them edit access to the protected source workbook.

- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- Sharing a connected Excel view via SharePoint or Microsoft Teams where the underlying source data must remain protected.
- Observed behavior
- The Excel view file only updates when the owner or specific team members open it; other colleagues cannot trigger a data refresh.
Ensure you have Site Administrator or Owner permissions in SharePoint and Teams to modify folder access settings and data connection properties.
Configure SharePoint Permissions and Refresh Settings
Grant your colleagues the necessary read permissions for the source workbook and enable background data refresh to ensure the view updates automatically.
Data connections in Excel require proper authentication. If colleagues do not have at least read access to the directory hosting the source file, the refresh operation will fail when they open the view file.
Navigate to your SharePoint site, locate the folder containing the source workbook, click 'Manage Access', and ensure your colleagues have at least 'Read' or 'View' permissions. This allows the data connection to authenticate without granting edit rights.
Open the Excel view file. Go to the 'Data' tab, click 'Queries & Connections', right-click your active connection, and select 'Properties'. Under the 'Usage' tab, check the box labeled 'Refresh data when opening the file'.
Save your changes to the view file. Notify a colleague to open the file through Teams or SharePoint to verify that the data updates automatically upon opening.

Utilize Power Query for Secure Data Import
Create a controlled data pipeline using Power Query to prevent colleagues from directly interacting with the protected source workbook.
Use Excel Sheet Views for Independent Filtering
If users simply need to filter and sort data without disrupting others or altering the source file, deploy Sheet Views in Excel for the Web.
Try WPS Office for Seamless Spreadsheet Collaboration
If managing complex SharePoint permissions and Excel data connections becomes overwhelming, WPS Office provides a lightweight, highly compatible alternative. Enjoy seamless collaboration, cloud document sharing, and robust spreadsheet features completely free of charge.
- 1. Download and Install WPS Office: Visit the official WPS Office website to download and install the free suite on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Microsoft Excel (.xlsx) files seamlessly without formatting loss.
- 3. Collaborate via WPS Cloud: Upload the file to WPS Cloud to easily manage viewing permissions, share securely with colleagues, and track edits in real-time.

Frequently Asked Questions
Why does my Excel SharePoint view show outdated data for external colleagues?
External colleagues or team members might lack the underlying read permissions for the source file connected to the view. Without these permissions, Excel cannot authenticate the data connection to pull the latest information upon opening.
Can I allow data refresh without giving edit access to the source workbook?
Yes. You can place the source workbook in a SharePoint library where colleagues have 'View' or 'Read-only' access. This allows data connections within a shared dashboard to refresh correctly without exposing the raw source file to unwanted edits.
What is the difference between an Excel Sheet View and a connected workbook view?
A Sheet View is a feature in Excel for the Web that lets individual users filter and sort data independently without affecting the display for other collaborators. A connected workbook view relies on external data connections to continuously pull data from a separate, protected source file.




