File Sharing Problems

Fix OneDrive Excel Sharing Link Requires Sign-In to Edit

Adam Davis Oct 1, 2026 869 views

Question details

Users need to resolve an issue where an Excel file shared via OneDrive requires authentication, even when the link is set to allow anyone to edit.

How to Fix a OneDrive Excel Sharing Link Requiring Sign-In

Product: Microsoft Excel / OneDrive
Device & OS: not provided
Scenario: A user generates a sharing link for an Excel file configured for 'Anyone with the link' to edit, but recipients are unexpectedly prompted to sign in.
Observed behavior: Instead of opening the file directly for anonymous editing, the OneDrive link redirects the recipient to a Microsoft authentication page demanding a login.

Before you start

Before proceeding, confirm your internet connection is stable and ask the recipient to open the sharing link in an incognito or private browsing window to rule out conflicting cached browser credentials.

Solution 1Recommended

Check Microsoft 365 Service Health and Verify Link Permissions

Verify if a Microsoft server outage is causing the issue, and ensure external sharing policies and link settings are correctly configured for anonymous access.

Authentication prompts for 'Anyone' links are most commonly caused by temporary Microsoft 365 service incidents affecting OneDrive, or by organizational policies overriding individual file sharing settings.

Check Service Status

Visit the Microsoft 365 service health dashboard at portal.office.com/ServiceStatus to check for any ongoing incidents affecting OneDrive or Office on the web. If there is an outage, wait until it is resolved.

Verify Link Settings

Navigate to your OneDrive, right-click the target Excel file, and click 'Share'. Click on the settings gear icon or the permission level and ensure 'Anyone with the link' is selected. Verify that the 'Allow editing' checkbox is explicitly ticked, then click 'Apply'.

Create and Test a New Link

Click 'Copy link' to generate a fresh sharing URL. Open a private or incognito window in your browser (where you are not signed into any Microsoft account) and paste the link to verify if it opens the Excel file without a sign-in prompt.

Check Microsoft 365 Service Health and Verify Link Permissions

Tenant Policy Restrictions: If you are using a Microsoft 365 work or school account, your organization's IT administrator may have disabled anonymous sharing globally. You will need to contact your IT department to allow anonymous editing.

Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

If you are tired of complex sharing permissions and unexpected sign-in hurdles, switch to WPS Office. It provides a lightweight, highly compatible, and easy-to-use platform for your spreadsheet collaboration needs.

1. Download and Install: Download WPS Office from the official website and install it on your device.
2. Upload to WPS Cloud: Open your spreadsheet in WPS Office and save it directly to your free WPS Cloud storage.
3. Share with Ease: Click the 'Share' button in the top right corner to instantly generate a public or secure link for fast, hassle-free collaboration.

Completely free and lightweight Office suiteFully compatible with Microsoft Excel (.xlsx, .xls) and other Office formatsEasy and reliable file sharing via WPS Cloud without confusing permission barriersFamiliar user interface ensuring zero learning curve and seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why does my OneDrive link suddenly ask for a login?

This can happen due to a temporary service incident on Microsoft's servers, or if an IT administrator for your work or school account recently updated security policies to block anonymous external sharing.

Can I share an Excel file without requiring the recipient to have a Microsoft account?

Yes, provided your account allows it. When generating the link, you must specifically choose 'Anyone with the link' and check the 'Allow editing' option in the sharing settings menu.

How can I accurately test if my sharing link works for anonymous users?

The most reliable way to test your sharing link is to open it in a private (Incognito) browsing window. This ensures no existing account credentials are automatically passed to the browser, simulating the experience of an external user.

Document & File Issues