Fix Microsoft Lists Anonymous Link Still Requires Sign-In
Question details
Users are trying to share a Microsoft List via an anonymous link, but recipients are unexpectedly prompted to sign in to a Microsoft account to view or edit it.

- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Generating a sharing link intended for external users without requiring Microsoft account authentication.
- Observed behavior
- The generated sharing link ignores the disabled login requirement and forces the recipient to sign in before granting access to the list.
Confirm whether you are using a personal Microsoft 365 subscription or an enterprise/organizational account, as sharing capabilities differ significantly between the two.
Verify Account Type and Personal Account Limitations
Check if you are using a personal Microsoft 365 account, as these accounts do not support true anonymous sharing for Microsoft Lists.
If you are using Microsoft 365 privately (such as a Family or Personal subscription) rather than through a business or school, true anonymous sharing for Microsoft Lists is often restricted by design. Unlike SharePoint-backed enterprise accounts, personal accounts generally require recipients to authenticate to access shared lists.
Log into your Microsoft account dashboard and navigate to 'Services & subscriptions' to confirm whether you are on a personal or business plan.
Instead of generating an anonymous link, click 'Share' in your Microsoft List and type the specific email addresses of your recipients. They will receive a direct invitation.
If you must share data with users who refuse to sign in, click 'Export' > 'Export to CSV' or 'Export to Excel' from the top menu of your list, and send the downloaded file directly.

Generate an 'Anyone with the link' URL (Organizational Accounts)
If your list is stored in SharePoint via a business account, ensure you are generating the correct link type.
Request Admin to Modify External Sharing Policies
Organizational administrators may need to adjust tenant-wide SharePoint settings to allow anonymous links.
Share List Data Without Sign-in Hassles Using WPS Office
If Microsoft Lists restricts your external sharing capabilities or forces users to log in, you can easily export your list data to an Excel spreadsheet and manage it with WPS Office. WPS Office is a free, lightweight suite that lets you edit and share your data locally or via your preferred file-sharing method without mandatory sign-ins.
- 1. Export your List: In Microsoft Lists, click 'Export' and select 'Export to Excel' to save your data as an .xlsx file.
- 2. Open with WPS Office: Install WPS Office and open the exported file using WPS Spreadsheet to continue managing your data.
- 3. Share effortlessly: Save and send the spreadsheet file directly to your contacts via email or chat, bypassing any cloud login requirements.

Frequently Asked Questions
Why does my personal Microsoft 365 account block anonymous list sharing?
Personal Microsoft accounts lack the advanced SharePoint backend infrastructure that supports 'Anyone with the link' functionality for Microsoft Lists. You generally need a business or enterprise subscription to utilize fully anonymous sharing features.
How can I share my Microsoft List data with non-Microsoft users?
The most reliable workaround for non-business accounts is to export the Microsoft List to an Excel file (.xlsx) or CSV format. You can then attach the file to an email or share it via a standard cloud storage link that doesn't enforce sign-ins.
Can SharePoint administrators block anonymous links?
Yes, organizational IT policies frequently restrict external sharing to protect company data. If an administrator disables 'Anyone' links in the SharePoint Admin Center, it overrides all individual list permissions, forcing external users to authenticate.




