'%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)
How to Share a Live OneDrive Excel Link with External Recipients
Question details
The user needs to share a live Excel spreadsheet via OneDrive with external recipients without forcing them to sign in to a Microsoft account.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Sharing an Excel file stored on OneDrive with external clients, partners, or collaborators who may not be part of the same organization.
- Observed behavior
- External recipients are encountering unexpected sign-in prompts when trying to access the shared OneDrive link due to restricted or organization-only permissions.
Ensure your Excel file is successfully synced to your OneDrive account and verify that your organization's IT policies permit external file sharing.
Modify OneDrive Sharing Settings for External Access
Change the link permissions to 'Anyone with the link' so external recipients can access and edit the Excel file without needing to sign in.
By default, OneDrive often restricts sharing links to people within your organization or specific invited users. To allow external guests to access your live spreadsheet smoothly, you must adjust the link settings to bypass the authentication requirement.
Locate your Excel file in OneDrive or open it in the Excel app, then click the 'Share' button located in the top-right corner of the screen.
In the sharing dialog box, click on the current permission level displayed (for example, it might say 'People in your organization with the link can view').
From the list of sharing options, select 'Anyone with the link'. This is the crucial step that prevents the sign-in prompt for external users.
Under 'Other settings', check the box for 'Allow editing' if you want recipients to modify the file. Click 'Apply', then click 'Copy link' to generate the URL for your external recipients.
Share Live Spreadsheets Seamlessly with WPS Office
If you are struggling with complex OneDrive permission policies, WPS Office provides a straightforward, built-in cloud sharing feature. You can effortlessly generate accessible links for external users while maintaining complete compatibility with Excel formats.
- 1. Open your file in WPS: Launch WPS Spreadsheets and open the document you wish to share.
- 2. Click Share: Click the 'Share' button located at the top right of the application window.
- 3. Set Permissions: Choose 'Anyone with the link' and specify whether they can view or edit the document.
- 4. Create and send the link: Click 'Create Link' to instantly generate a URL that you can copy and paste to your external collaborators.
Frequently Asked Questions
Why is my external recipient prompted to sign in to OneDrive?
This occurs when the sharing link is set to 'Specific people' or 'People in your organization'. The recipient is prompted to verify their identity. Changing the setting to 'Anyone with the link' will remove this requirement.
Can external users edit the Excel file without a Microsoft account?
Yes. As long as you generate an 'Anyone with the link' URL and enable the 'Allow editing' option before copying the link, external users can edit the spreadsheet directly in their web browser anonymously.
How do external recipients open the shared OneDrive link in their desktop app?
Once they open the live link in their web browser, they can click the 'Viewing' or 'Editing' dropdown menu on the top ribbon and select 'Open in Desktop App'. This will launch the file in their installed spreadsheet software, such as Excel or WPS Office.
What should I do if the 'Anyone with the link' option is greyed out?
If this option is disabled, it means your organization's IT department has restricted anonymous external sharing for security reasons. You will need to contact your IT administrator to request external sharing permissions or ask for an alternative approved method to send the file.
