Permission & Access Issues

How to Configure SharePoint Access to Refresh Excel Data Connections

Partner Editor Sep 30, 2026 870 views

Question details

The user needs to know the exact permission level required for Excel users to refresh a workbook's data connection linked to a SharePoint list.

How to Configure SharePoint Access to Refresh Excel Data Connections

Product: Microsoft Excel
Device & OS: not provided
Scenario: Refreshing a data connection in an Excel workbook where the underlying data source is hosted on a SharePoint list.
Observed behavior: Determining whether full SharePoint site membership is required or if list-level access is sufficient for internal and external users.

Before you start

Determine whether the users who need to refresh the Excel workbook are internal members of your organization or external guests, as their access requirements and app limitations will differ significantly.

Solution 1Recommended

Grant List-Level Access for Internal Users

Internal users do not need access to the entire SharePoint site; granting them direct permissions to the specific SharePoint list is sufficient for refreshing the Excel data connection.

By default, SharePoint lists inherit permissions from the parent site. To grant access to just the list without exposing the whole site, you must break this inheritance and assign explicit permissions.

Navigate to List Settings

Open the SharePoint site as an administrator, go to the specific list used as your Excel data source, click the gear icon (Settings) in the top right corner, and select 'List settings'.

Access Permissions

Under the 'Permissions and Management' section, click on 'Permissions for this list'.

Stop Inheriting Permissions

Click the 'Stop Inheriting Permissions' button in the top ribbon to detach the list's security settings from the main SharePoint site.

Grant Access

Click 'Grant Permissions', enter the email addresses of the internal users who need to refresh the Excel file, ensure they have at least 'Read' access, and click 'Share'.

Grant List-Level Access for Internal Users

Permission verification: Once granted, internal users can successfully click 'Refresh All' in Excel to update their workbook data from the SharePoint list.

Solution 2

Configure Guest Access for External Users

External users face strict security boundaries. They require guest access to the tenant and must use the Excel Desktop App to refresh SharePoint data connections.

Free Microsoft Office alternative

Looking for a More Straightforward Spreadsheet Solution?

If managing complex SharePoint site permissions, external guest accesses, and Microsoft Office subscriptions is complicating your workflow, consider switching to WPS Office. It provides a highly compatible, free, and lightweight alternative for everyday spreadsheet tasks.

1. Download the Software: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install WPS Office: Run the installer and launch the suite. WPS Spreadsheets will be available immediately.
3. Edit Seamlessly: Open your existing .xlsx files directly in WPS Spreadsheets. Your formatting, formulas, and data will remain perfectly intact.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight application with blazing fast performance and low system requirementsFamiliar user interface that requires zero learning curveEasy file sharing and local data management without complex permission hurdles

microsoft office alternative - wps office

Frequently Asked Questions

Why does an external user get an error when refreshing the Excel connection in their browser?

Excel for the Web does not support refreshing external data connections for guest accounts due to security restrictions. External users must open the file in the Microsoft Excel Desktop app and authenticate their guest account to successfully refresh the data.

Can I give users access to a SharePoint list without them seeing the rest of the site?

Yes. By navigating to the specific list's settings and selecting 'Stop Inheriting Permissions', you can grant users direct 'Read' access to just that list. They will not be able to browse the broader SharePoint site's documents or pages.

Do users need 'Edit' access to the SharePoint list to refresh the Excel data?

No. Users only need 'Read' access to the underlying SharePoint list to pull the latest data into their Excel workbook. 'Edit' access is only required if they need to modify the raw data directly within SharePoint.

Will breaking permission inheritance on a SharePoint list affect existing users?

When you select 'Stop Inheriting Permissions', SharePoint copies the current site permissions to the list. Existing users will retain their access unless you explicitly select and remove them from the list's permission settings.

Document & File Issues