Fix SharePoint List Export to Excel and Access Connection Errors
Question details
The user needs to export a SharePoint list to Excel or connect it to Microsoft Access without an authentication error.

- Product
- SharePoint Online, Microsoft Excel, and Microsoft Access
- Device & OS
- not provided
- Scenario
- An authenticated Microsoft 365 user tries to export a SharePoint list to Excel or connect it to Access.
- Observed behavior
- Export to Excel prompts the user to sign in again and then returns an error. The Access connection also fails, although Excel Get Data can connect to the list.
Have the SharePoint site URL, the affected list name, and the exact error message ready. Confirm which Microsoft 365 account you use for the site and whether you can open the list in your browser.
Isolate the SharePoint Authentication Problem
Compare lists, browsers, and networks to identify whether the error is specific to the site, session, or environment.
Open a different SharePoint list, preferably on another site, and select Export to Excel. Note whether the same sign-in prompt and error appear.
Open the list in another browser or a private browsing window, sign in with the account that has access to the list, and select Export to Excel again.
With your organization's approval, try the export on another trusted network. Ask your administrator to check whether a VPN, proxy, firewall, or conditional-access policy is affecting authentication; do not disable security controls without approval.
Ask the SharePoint administrator to check your list permissions and any site security, sharing, or client-access restrictions that could affect exporting or connecting from Office apps.

Use Excel Get Data to Load the SharePoint List
Use this workaround when Excel can connect to the list even though the SharePoint Export to Excel command fails.
Escalate Persistent Export and Access Errors
Contact your Microsoft 365 administrator or Microsoft Support if the issue persists across lists, browsers, or networks.
Work With Exported Excel Files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface. Once you have obtained the list as an Excel file, you can open and edit it in WPS Spreadsheets for an easier transition between office suites. WPS does not fix SharePoint authentication or the Access connection.

Frequently Asked Questions
Why does SharePoint ask me to sign in again when I export a list?
The export may use a different authentication flow from the browser session. Test in a private window and ask your administrator to check conditional-access, proxy, VPN, firewall, and site policies.
Can I get the list into Excel if Export to Excel fails?
If the connector works in your Excel version, select Data > Get Data > From Online Services > From SharePoint Online List, enter the site URL, and sign in with your organizational account.
Does a working Get Data connection mean SharePoint export is fixed?
No. Get Data is a separate way to load the list. The SharePoint export command and the Access connection can still fail and may need an administrator or Microsoft Support to investigate.
What should I send my administrator about the Access and Excel errors?
Provide the exact error text, site and list details, browser and Office versions, failure time, and results from other lists and networks. Mention that Excel Get Data connects successfully, but do not send passwords or tokens.




