'%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 Excel Spreadsheet Stored in OneDrive on Android
Question details
The user is unable to enter data or edit a shared Excel workbook stored in OneDrive while using an Android device, and may be prompted to install a mobile app.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- Android
- Scenario
- Accessing and attempting to edit a shared Excel spreadsheet via a OneDrive link on an Android mobile device.
- Observed behavior
- The spreadsheet opens in a read-only state or the user is blocked from entering data, often accompanied by a prompt to install a dedicated mobile app.
Ensure that your Android device is connected to a stable internet network and that you are logged into the Microsoft account associated with the shared file link.
Verify Sharing Permissions and Use a Compatible Mobile App
Ensure the sender has granted edit access in the sharing link and open the file using a dedicated mobile spreadsheet application instead of a mobile web browser.
While Excel for the web allows editing on desktop browsers, mobile web browsers on Android often lack full support for data entry. Opening the link on a phone may require a dedicated mobile app to enable editing capabilities.
Contact the person who shared the workbook and ask them to verify that the OneDrive link was created with the 'Allow editing' or 'Can edit' option selected.
If you are prompted to install an application when opening the link, go to the Google Play Store and download a compatible spreadsheet editor like Microsoft Excel or WPS Office.
Once the app is installed, tap the shared OneDrive link again and choose to open it with the newly installed app rather than your mobile browser.
Test with a New File to Rule Out Workbook Protection
Determine if the editing restriction is caused by specific worksheet protection settings applied to the original file by creating and testing a new spreadsheet.
Edit Excel Files on Android Seamlessly with WPS Office
If you are struggling to edit Excel files on your Android device due to app restrictions or complex account setups, WPS Office provides a free, lightweight, and highly compatible alternative. You can easily connect your cloud storage accounts and edit spreadsheets without hassle.
- 1. Install the App: Download WPS Office for free from the Google Play Store on your Android device.
- 2. Connect Your Cloud Storage: Open WPS Office, navigate to the 'Open' tab, select 'Add Cloud Storage', and sign in to your OneDrive account.
- 3. Open and Edit: Locate your shared Excel file within the OneDrive folder in WPS Office, tap to open it, and begin editing your data immediately.
Frequently Asked Questions
Why does my shared OneDrive Excel link open as read-only on my phone?
This usually happens for two reasons: either the sender created a 'View only' link instead of an editable one, or your mobile web browser restricts editing features, requiring you to use a dedicated mobile spreadsheet app.
Can I edit Excel files on Android without installing the Microsoft Excel app?
Yes, you can use highly compatible third-party office suites like WPS Office to open, edit, and save Excel files downloaded or accessed from cloud storage on your Android device.
How can the file owner change the permissions on a shared OneDrive file?
The file owner needs to go to their OneDrive, select the file, click 'Share', click on the current link settings, check the 'Allow editing' box, and then apply the changes or generate a new link.
