Permission & Access Issues

How to Fix Excel Files Opening as Read-Only on iPhone

Khadija Khan Oct 1, 2026 868 views

Question details

User needs to know why certain Excel files are locked in read-only mode or require sign-in on the iOS app, despite appearing to have the same permissions as editable files.

How to Fix Excel Files Opening as Read-Only on iPhone

Product: Microsoft 365 / Excel app
Device & OS: iPhone (iOS)
Scenario: Opening and editing synchronized Excel files on a mobile device.
Observed behavior: Some synchronized Excel files open normally for editing, while others are restricted to read-only or prompt for account sign-in despite being synced through the same OneDrive account.

Before you start

Ensure you have a stable internet connection for OneDrive synchronization and verify that you are using the exact same Microsoft account across all your devices.

Solution 1Recommended

Refresh Your Account and Update the App

Use this solution to resolve authentication glitches and software bugs that cause the app to mistakenly lock files.

Authentication tokens on mobile devices can sometimes expire or glitch, causing the app to think you do not have permission to edit a file. Signing out and updating the app resets these permissions.

Sign out of your account

Open the Microsoft 365 or Excel app on your iPhone, tap your profile picture in the top left corner, select 'Settings', and tap 'Sign Out'.

Update iOS and Excel

Go to the App Store, search for Excel, and tap 'Update' if available. Additionally, check your iPhone Settings > General > Software Update to ensure your iOS is up to date.

Sign back in

Reopen the Excel app and sign back in using the Microsoft account associated with your Microsoft 365 subscription.

Tip: If the issue persists after signing back in, try uninstalling and reinstalling the Excel app completely to clear cached data.

Solution 2

Check File Format and Active Sessions

Use this method if specific files are read-only while others are editable, as it usually indicates a file-specific lock or compatibility issue.

Solution 3

Adjust OneDrive Synchronization Settings

Use this if the file appears to be stuck syncing or if offline access settings are causing read-only conflicts.

Free Microsoft Office alternative

Edit Spreadsheets Seamlessly on iPhone with WPS Office

If you are tired of frustrating read-only locks, sign-in prompts, and sync issues, try WPS Office. It is a lightweight, free alternative that allows you to effortlessly view and edit Excel files directly on your iPhone.

1. Install the app: Download WPS Office from the Apple App Store.
2. Open your file: Launch WPS Office, tap 'Files', and select the spreadsheet you want to edit.
3. Start editing: Tap the 'Edit' button to modify cells, formulas, and formatting without read-only restrictions.

100% compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsNo mandatory sign-in required to perform basic local editsLightweight mobile app optimized for smooth performance on iOSSeamless integration with iCloud, Google Drive, and other cloud services

microsoft office alternative - wps office

Frequently Asked Questions

Why does my iPhone say the Excel file is locked for editing?

This usually happens if the file is currently open on another device (like your PC or Mac). Excel locks the file to prevent conflicting changes. Closing the file on your other device will remove the lock.

Can I edit older .xls files on the Excel iPhone app?

The Excel mobile app often opens older .xls files in read-only mode. To edit them, you must save a copy of the file in the newer .xlsx format.

How do I turn off read-only mode in Excel for iOS?

You cannot disable read-only mode with a single toggle if it's caused by missing permissions or unsupported formats. However, you can bypass it by tapping 'Save a Copy' to create a new, fully editable version of the document.

Does my Microsoft 365 subscription status affect read-only files?

Yes. If your subscription has expired, or if you are not signed into the account associated with an active subscription, the app will restrict your editing privileges and open files in read-only mode.

Document & File Issues