'%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 Excel Sharing Link Asking Mobile Users to Sign In
Question details
Users opening an Excel sharing link on mobile devices are unexpectedly prompted to sign in, even when the link is set to anonymous viewing.
- Product
- Microsoft Excel
- Device & OS
- Mobile (iOS / Android)
- Scenario
- Sharing an Excel spreadsheet using an 'Anyone with the link can view' URL for external users to access on their mobile devices.
- Observed behavior
- The shared link works perfectly on desktop browsers without authentication, but forces users to sign in with a work or school account when opened on a mobile device with the Excel app installed.
Before altering link permissions to bypass sign-in requirements, ensure your spreadsheet does not contain sensitive personal or financial information, and consider creating a separate duplicate copy for public sharing.
Modify Link Permissions to Allow Editing
Changing the link permission from view-only to editing often bypasses the mobile app's strict sign-in requirement.
The Microsoft Excel mobile app handles anonymous links differently than a desktop browser and sometimes forces authentication for view-only links. By switching the permission to 'Allow editing', you can usually bypass the account prompt. To prevent unauthorized changes to your data, you must protect the worksheet before sharing.
Open your Excel workbook on your desktop. Go to the 'Review' tab on the ribbon, click 'Protect Sheet', enter a secure password, and click 'OK' to lock the cells.
Click the 'Share' button located in the top-right corner of the Excel window to open the link generation menu.
Click on the current link settings to expand the permissions menu and select 'Anyone with the link'.
Check the box next to 'Allow editing' and click 'Apply'. Copy this new link and distribute it to your mobile users.
Instruct Users to Open the Link in a Mobile Web Browser
Guide recipients to bypass the installed Excel mobile app and view the file directly in their mobile browser.
Share Spreadsheets Seamlessly with WPS Office
If Microsoft Excel's mobile app permissions continue to cause frustrating sign-in roadblocks for your recipients, consider switching to WPS Office. It provides a straightforward, free alternative with easy cloud sharing that doesn't force unnecessary logins on mobile devices.
- 1. Open spreadsheet: Launch WPS Office and open your desired spreadsheet file.
- 2. Click Share: Tap or click the 'Share' button at the top right of the interface.
- 3. Create public link: Select 'Create Link', set the permission to 'Anyone with the link can view', and copy the URL.
- 4. Send to mobile users: Share the link with your mobile recipients for hassle-free anonymous access.
Frequently Asked Questions
Why does my Excel link work on desktop but not on mobile?
The Microsoft Excel mobile app processes sharing links differently than desktop web browsers. When the mobile app intercepts the link, it may enforce organizational policies or Microsoft 365 licensing checks, prompting for a work or school account even if the link is meant for anonymous viewing.
How can I share an Excel file on mobile without anyone being able to edit it?
If you use the 'Allow editing' workaround to bypass the sign-in prompt, you must use the 'Protect Sheet' feature found in the 'Review' tab. Setting a password locks the cells, ensuring that even though the link allows editing globally, no actual changes can be made to the data.
Can I force an Excel sharing link to open in the browser instead of the app?
You cannot force this behavior from the sender's side. The recipient must manually choose how to open the link by long-pressing it on their mobile device and selecting 'Open in browser' to avoid launching the Excel app.
Will sharing a separate copy fix the mobile sign-in issue?
Sharing a separate copy does not fix the sign-in issue by itself, but it is a highly recommended safety measure if you choose to bypass the sign-in prompt by changing the link permissions to 'Allow editing'. It ensures your original document remains untouched.
