Permission & Access Issues

Fix Excel Access Forbidden When Importing a SharePoint Folder

Kushani NimanthikaKushani Nimanthika Nov 13, 2026 870 views

Question details

The user needs to import files from a SharePoint folder into Excel without receiving an access-forbidden error.

Fix Excel Access Forbidden When Importing a SharePoint Folder
Product
Microsoft Excel Power Query and SharePoint
Device & OS
not provided
Scenario
The user selects Get Data from a SharePoint Folder and can access the files in SharePoint.
Observed behavior
Excel reports that access to the resource is forbidden, even though the user can access the files and created the workbook.
Before you start

Confirm that you can open the SharePoint site in a browser with the account you intend to use in Excel. Copy the site URL, rather than a link to an individual file.

Solution 1Recommended

Clear Saved SharePoint Permissions and Reconnect

Use this method when Excel has saved an incorrect authentication method or account for the SharePoint source.

1
Open data source settings

In Excel, select Data > Get Data > Data Source Settings.

2
Clear the saved permissions

Find the relevant SharePoint source, select it, and choose Clear Permissions. Confirm the prompt.

3
Reconnect to the site

Select Data > Get Data > From File > From SharePoint Folder, enter the SharePoint site URL, and select OK.

4
Choose the correct account

In the sign-in dialog, choose Organizational account for a work or school account, or Microsoft account if appropriate for a personal account. Sign in with the account that can access the site, then select Connect.

Clear Saved SharePoint Permissions and Reconnect
Check the permission scope: If the error persists, check Data Source Settings for another saved permission entry covering the same SharePoint site. Clearing permissions may require you to sign in again.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for Excel formats, making it easy to move between office suites. Use it to work with downloaded spreadsheets; it does not fix Excel's SharePoint connector permissions.

Open and edit downloaded spreadsheets from SharePointCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can I open SharePoint files in my browser but not import them into Excel?

Excel may have saved a different account or authentication method for the SharePoint source. Open Data > Get Data > Data Source Settings, clear the source permissions, and reconnect with the account you use in your browser.

Which URL should I enter for the SharePoint Folder connector?

Enter the SharePoint site URL in Data > Get Data > From File > From SharePoint Folder, rather than a link to an individual file.

Should I choose Microsoft account or Organizational account?

Choose Organizational account for a work or school account. Choose Microsoft account when a personal Microsoft account is appropriate for the SharePoint source.

What should I do if reconnecting does not fix the error?

Check Data Source Settings for another saved entry covering the site, confirm your account can access the site in a browser, and update Office through File > Account > Update Options > Update Now if available.