'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix OneDrive Anyone Links Asking Recipients to Sign In to Word or Excel
Question details
Users sharing personal OneDrive files via 'Anyone with the link' find that recipients are unexpectedly prompted to sign in when attempting to open the files in Word or Excel for the web.
- Product
- Microsoft OneDrive
- Device & OS
- not provided
- Scenario
- Sharing documents using anonymous OneDrive links so recipients can view them directly in web browsers.
- Observed behavior
- While downloading the files works without authentication, opening the files in Word or Excel web apps prompts the recipient to sign in or displays an error, particularly for users with business or government accounts.
Verify that your OneDrive sharing link was explicitly set to 'Anyone with the link' and that the link has not expired.
Download Files and Open with Desktop Applications
Since the online viewer has authentication limitations, downloading the file directly bypasses the web sign-in prompt.
This behavior is often caused by limitations or bugs in the Microsoft Office web viewer itself, rather than incorrect link settings. Bypassing the web viewer entirely is the most reliable workaround.
Click the provided OneDrive link. When the file list appears in your browser, do not click the file name directly, as this attempts to open it in the web app.
Hover over the file or folder you want to view and click the circular checkbox that appears next to it.
Click the 'Download' button on the top menu bar to save the file to your local computer.
Open the downloaded document using an installed desktop application like WPS Office or Microsoft Word/Excel.
Re-verify Sharing Link Permissions
Ensure the link was generated with the correct anonymous access permissions from the start.
Easily Open and Edit Documents with WPS Office
Avoid the frustrating sign-in loops and limitations of Microsoft Office web viewers. WPS Office is a free, lightweight, and highly compatible alternative that lets you open, edit, and share Word, Excel, and PDF files directly on your desktop.
- 1. Download WPS Office: Get the free WPS Office installer from the official website.
- 2. Install the software: Follow the straightforward on-screen instructions to complete the installation.
- 3. Open your downloaded files: Right-click the file downloaded from OneDrive and select 'Open with WPS Office' to view and edit without any sign-in prompts.
Frequently Asked Questions
Why does the OneDrive 'Anyone' link work for downloading but not for web viewing?
This is a known limitation in the OneDrive web viewer. While downloading works anonymously, Microsoft's web apps (Word or Excel for the web) often enforce authentication to load specific viewer components, especially if the recipient's browser is logged into a business or government account.
Can I force the OneDrive link to open without sign-in?
Unfortunately, if the link is correctly set to 'Anyone with the link' and it still prompts for sign-in, there is no direct setting to force the web viewer to bypass it. Recipients must download the file to view it locally.
Does this sign-in issue happen with all file types on OneDrive?
This issue primarily affects Office documents like Word (.docx), Excel (.xlsx), and PowerPoint (.pptx) files that trigger the Microsoft Office web applications. Simpler files like PDFs or images typically preview without requiring a sign-in.
