Fix SharePoint List Export to Excel for an External User
Question details
An external SharePoint user needs to export a list to Excel without repeated account or password prompts.

- Product
- Microsoft SharePoint and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A guest user can access a SharePoint site and perform other actions but encounters sign-in problems when exporting a list to Excel.
- Observed behavior
- Excel repeatedly prompts for a Microsoft account password or reports that the account or password is incorrect. Other users with similar permissions can export successfully.
Confirm which account was invited to the SharePoint site and note the exact error message and where it appears. Ask another guest with similar permissions to test the same list for comparison.
Test the Export in a Fresh Browser Session
Use a private window or another browser to check whether the problem is tied to the current browser session.
Open an incognito or private browsing window, go to the SharePoint site, and sign in with the account that received the guest invitation.
Open the affected list and select Export > Export to Excel. Open the downloaded file and record whether the prompt appears in the browser or in Excel.
Repeat the export in a different browser, such as Firefox or Edge. If it works there, clear the affected SharePoint site's cookies and cache in the original browser's settings, then sign in and try again.

Compare Lists and Try Classic SharePoint
Use these checks to determine whether the issue is limited to one list or the current SharePoint experience.
Check the Guest Account Used by Excel
Use this check when Excel opens the export but rejects the account or repeatedly requests a password.
Work With Exported Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with compatible spreadsheets. It can help you move existing Office files into a new workflow, but it does not resolve SharePoint guest authentication or guarantee support for a SharePoint export connection.

Frequently Asked Questions
Why can I access the SharePoint site but not export its list to Excel?
The browser and Excel may use different sign-in sessions. Check which account was invited to the site, then review the account shown under Excel's File > Account and retry the export.
What should I do if an incognito window still leads to a password error in Excel?
Try the export in another browser, then check the account used at the Excel sign-in prompt. If the error continues, give the site administrator the exact message and your test results.
How can I tell whether the problem affects one SharePoint list or my account?
Use Export > Export to Excel on another list you can access, and ask a guest with similar permissions to export the original list. If only your account fails across lists, the issue may be specific to your account or session.
Can WPS Office fix the SharePoint password prompt?
No. The prompt is a SharePoint or Excel authentication issue. WPS Office can open compatible Excel workbooks, but it does not fix guest access or guarantee support for the SharePoint export connection.




