Fix Excel Access Forbidden When Importing a SharePoint Folder
Question details
The user needs to import files from a SharePoint folder into Excel without receiving an access-forbidden error.

- 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.
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.
Clear Saved SharePoint Permissions and Reconnect
Use this method when Excel has saved an incorrect authentication method or account for the SharePoint source.
In Excel, select Data > Get Data > Data Source Settings.
Find the relevant SharePoint source, select it, and choose Clear Permissions. Confirm the prompt.
Select Data > Get Data > From File > From SharePoint Folder, enter the SharePoint site URL, and select OK.
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.

Update Office and Retry the SharePoint Connection
Try an Office update if clearing permissions and signing in again does not resolve the error.
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.

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.




