'%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 Cannot Edit Shared Excel Spreadsheet in OneDrive on Mobile
Question details
The user is unable to edit a shared Excel spreadsheet on their mobile device; the file unexpectedly opens in view-only mode, particularly when accessed through links on Facebook.
- Product
- Microsoft Excel / OneDrive
- Device & OS
- Mobile devices
- Scenario
- Attempting to edit a shared spreadsheet on a mobile phone via OneDrive integration linked from Facebook.
- Observed behavior
- The spreadsheet opens in view-only mode, editing options are missing, and tapping 'Edit in Excel' has no effect.
Verify that you are logged into the correct Microsoft account with editing permissions for the shared file, and ensure your OneDrive and Excel mobile applications are updated to the latest versions.
Open the File Directly in the OneDrive App
Bypassing third-party apps like Facebook prevents integration glitches that force files into view-only mode on mobile devices.
A recent OneDrive update may prevent files opened through another application's in-app browser from being edited properly.
Exit the Facebook application or the third-party browser where you originally clicked the shared spreadsheet link.
Locate and open the official OneDrive mobile app on your smartphone or tablet.
Tap on the 'Shared' tab at the bottom navigation menu to view files shared with you.
Find the target Excel spreadsheet and tap to open it. It should now launch directly in the Excel app with full editing options available.
Save a Local Copy to Edit
Due to certain OneDrive updates or permission changes, the application may require you to save a copy of the file before editing is allowed.
Use WPS Office for Hassle-Free Mobile Editing
If you continue experiencing view-only issues and restrictive integrations with Microsoft Excel on mobile, consider switching to WPS Office. It provides a lightweight, seamless mobile editing experience with a familiar interface, high compatibility, and eliminates many of the common sharing glitches.
- 1. Download WPS Office: Install WPS Office from your mobile app store.
- 2. Open Your Spreadsheet: Launch the app and use the file manager to locate your downloaded or shared spreadsheet.
- 3. Edit Easily: Tap 'Edit' to make seamless modifications without view-only restrictions.
Frequently Asked Questions
Why does my shared Excel file open in view-only mode on mobile?
This typically occurs when opening files through third-party apps like Facebook, which use restrictive in-app browsers. It can also happen if you lack edit permissions or due to compatibility glitches following a recent OneDrive update.
How do I fix the 'Edit in Excel' button not working?
If the button is unresponsive, try copying the shared link and pasting it directly into your device's native browser (like Chrome or Safari), or open the file directly from within the OneDrive mobile app.
Does opening an Excel link from Facebook prevent editing?
Yes, Facebook's in-app browser often limits full functionality for Microsoft Office links, which can result in the spreadsheet being locked in view-only mode and the 'Edit in Excel' button having no effect.
