'%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 Fix Excel Files Opening as Read-Only on Android
Question details
The user is unable to edit an Excel spreadsheet because it automatically opens in read-only mode when accessed from a business OneDrive account on their mobile device.
- Product
- Microsoft Excel for Android
- Device & OS
- Android
- Scenario
- Accessing and attempting to edit a business OneDrive Excel file on an Android smartphone or tablet.
- Observed behavior
- The file opens as read-only, preventing edits, which is often caused by Microsoft 365 authentication conflicts or missing permissions.
Verify that your internet connection is stable and ensure the file owner has actually granted your business account editing permissions for the document.
Remove and Re-add Your Microsoft 365 Account
Clearing conflicting account credentials resolves the authentication errors that force the app into read-only mode.
If you have multiple Microsoft accounts on your device, Excel may attempt to authenticate using an account that lacks permission to edit the file.
Navigate to your Android device Settings, tap on 'Accounts' or 'Users & Accounts', select the conflicting Microsoft 365 account, and tap 'Remove account'.
Open your recent apps menu on Android, swipe away the Microsoft Excel app to close it completely, then reopen the app.
Sign back in using the exact business credentials associated with the OneDrive file and try opening the spreadsheet again.
Open the File via OneDrive in a Web Browser
Bypassing the Android app and using Excel for the web can help you edit the file immediately without dealing with app-specific bugs.
Edit Excel Files on Android Seamlessly with WPS Office
Tired of account authentication issues causing read-only errors? WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office. It allows you to easily view, edit, and manage your spreadsheets on Android without frustrating sign-in conflicts.
- 1. Install WPS Office: Download and install the WPS Office app from the Google Play Store on your Android device.
- 2. Connect your Cloud Storage: Open WPS Office, navigate to the 'Cloud' tab, and sign in to your OneDrive account.
- 3. Edit without hassle: Tap the Excel file to open it and start editing immediately with full formatting and formula support.
Frequently Asked Questions
Why do my Excel files keep opening in read-only mode on Android?
This typically happens if the Microsoft 365 app selects the wrong account during authentication, if your subscription has expired, or if the file owner hasn't granted you edit permissions.
Can I edit a read-only Excel file by saving a local copy?
Yes. If you only have view access or face a syncing error, you can tap 'Save As' in the app menu to create a local copy on your Android device, which you will be able to edit freely.
How do I check if I have edit permissions for a OneDrive file?
Log into OneDrive via a web browser, locate the file, select 'Manage Access' or 'Details' from the file options, and verify if your account is listed with 'Can edit' rights.
