Permission & Access Issues

How to Fix Excel Files Opening as Read-Only on SharePoint or Teams

Huma Ashraf Ch Oct 22, 2026 870 views

Question details

Users are unable to collaboratively edit Excel workbooks stored on SharePoint or Microsoft Teams because the files open in read-only mode.

How to Fix Excel Files Opening as Read-Only on SharePoint or Teams

Product: Microsoft Excel, SharePoint, Microsoft Teams
Device & OS: not provided
Scenario: Attempting to open, edit, or co-author an Excel workbook collaboratively from a shared SharePoint document library or Microsoft Teams channel.
Observed behavior: The Excel file opens in read-only mode, disabling simultaneous editing and preventing users from saving changes directly to the shared location.

Before you start

Before proceeding, ensure your internet connection is stable, you are fully signed into your Microsoft 365 account with the correct credentials, and your browser or Teams app is up to date.

Solution 1Recommended

Verify File Permissions and Check-in Status

The most common reason for read-only access is lacking the necessary edit permissions or the file being locked because another user has checked it out.

SharePoint and Teams require explicit 'Edit' permissions for co-authoring. If a file is checked out, it is exclusively locked to one user until it is checked back in, forcing all other users into read-only mode.

Check file permissions

Navigate to the SharePoint library or Teams Files tab. Click the ellipsis (...) next to the Excel file, select 'Manage Access', and ensure your account has 'Edit' permissions rather than just 'View'.

Identify check-out status

Look for a small green arrow superimposed on the Excel file icon in SharePoint. This indicator means the file is currently checked out by a user.

Check the file back in

Click the ellipsis (...) next to the checked-out file, select 'More', and then click 'Check in' or 'Discard check out' to unlock it for other users.

Reopen the workbook

Refresh your Microsoft Teams or SharePoint page, and click the file name to open it again. Co-authoring should now be active.

Verify File Permissions and Check-in Status

Co-authoring Restored: Once the file is checked in and permissions are granted, multiple users can edit the document simultaneously without read-only restrictions.

Solution 2

Remove Unsupported Workbook Features

Certain legacy or security features in Excel are not supported for web-based co-authoring and will force the workbook into read-only mode.

Free Microsoft Office alternative

Experience Seamless Collaboration with WPS Office

If you frequently encounter read-only locks and permission sync issues with Microsoft Excel on SharePoint or Teams, consider switching to WPS Office. It is a free, lightweight alternative that provides excellent format compatibility and an easy-to-use cloud platform for team collaboration.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite.
2. Upload your files: Save your spreadsheets to WPS Cloud directly from the application workspace.
3. Collaborate in real-time: Share the document link with your team to start co-authoring instantly without permission conflicts.

Fully compatible with Microsoft Excel (.xlsx, .xls) filesLightweight application that uses minimal system resourcesFamiliar user interface requires no steep learning curveBuilt-in WPS Cloud for hassle-free real-time co-authoring

Frequently Asked Questions

Why does my Excel file say 'Read-Only' even when I have edit permissions?

The file might be checked out by another user, it may contain unsupported features like legacy shared workbook settings, or another user might have it open in an older desktop version of Excel that does not support co-authoring.

How do I find out who has the SharePoint Excel file checked out?

Hover over the file in the SharePoint document library. A pop-up card or the details pane on the right side will display the name of the user who currently has the file checked out.

Can I force a check-in on a SharePoint file if the user is unavailable?

Yes. If you have Site Owner or Administrator privileges, you can go to the document library settings and use the 'Manage files which have no checked in version' option, or directly select 'Discard check out' from the file's context menu.

Does password protection prevent co-authoring in Teams?

Yes. If an Excel workbook is encrypted with a password to open or modify, it cannot be co-authored simultaneously in Teams or Excel for the Web, and it will automatically open in read-only mode.

Document & File Issues