Permission & Access Issues

How to Fix Excel SharePoint View Not Updating for Colleagues

Aamir Naveed AkramAamir Naveed Akram Oct 29, 2026 869 views

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.

How to Fix Excel SharePoint View Not Updating for Colleagues
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.
Before you start

Ensure you have Site Administrator or Owner permissions in SharePoint and Teams to modify folder access settings and data connection properties.

Solution 1Recommended

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.

1
Adjust SharePoint Permissions

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.

2
Enable Auto-Refresh on Open

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'.

3
Save and Verify via Teams

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.

Configure SharePoint Permissions and Refresh Settings
Permission Applied Successfully: Setting the source file to 'Read-only' for colleagues perfectly balances the need to share updated dashboards while protecting your raw data.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS Office website to download and install the free suite on your device.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Microsoft Excel (.xlsx) files seamlessly without formatting loss.
  3. 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.
Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Built-in WPS Cloud collaboration for easy sharing and secure permissionsLightweight application that runs smoothly across Windows, Mac, and mobile devicesGranular document protection to securely restrict editing access
microsoft office alternative - wps office

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.