Permission & Access Issues

Fix SharePoint Files Opening Read-Only in Desktop Excel After Check-Out

Nimra MalikNimra Malik Nov 18, 2026 869 views

Question details

A SharePoint user needs to save changes to checked-out files directly from desktop Excel.

Fix SharePoint Files Opening Read-Only in Desktop Excel After Check-Out
Product
SharePoint and Microsoft Excel
Device & OS
not provided
Scenario
The affected user checks out a SharePoint file and opens it in the desktop Excel application.
Observed behavior
Excel opens the file as read-only, so changes must be saved locally and checked in through the SharePoint website. Another user on the same computer is unaffected.
Before you start

Identify the affected SharePoint account and a file and library where the issue occurs. Ask a SharePoint administrator to review access settings, and compare the affected account with the working account on the same computer.

Solution 1Recommended

Review SharePoint Access for Unmanaged Devices

Use this check when desktop access may be restricted for the affected user or device.

1
Open access controls

Ask an administrator to open the SharePoint admin center and select Access control > Unmanaged devices.

2
Review the access policy

Check whether the policy limits access from unmanaged devices. If permitted by your organization's security policy, select Allow full access from desktop apps, mobile apps, and the web and save the setting.

3
Check related policies

Ask the administrator to review applicable Microsoft Entra Conditional Access policies and device management status for the affected account and computer.

4
Retest in Excel

Open the checked-out file from the SharePoint library in desktop Excel, make a small change, and use Save to see whether it saves back to SharePoint.

Review SharePoint Access for Unmanaged Devices
Follow your organization's security policy: Allowing full access may change protections for unmanaged devices. An administrator should assess the impact before changing the setting.
Free Microsoft Office alternative

Edit Excel-Compatible Spreadsheets with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with them in WPS. SharePoint permissions and device-access policies still apply and must be resolved by your administrator.

Edit spreadsheet files in a familiar, easy-to-use interfaceOpen and save files in Microsoft Excel formats such as XLSXWork with local spreadsheet copies when appropriateMove existing compatible Office documents to WPS for a smooth transition
QA img-9

Frequently Asked Questions

Why can one user save the file while another cannot on the same computer?

The accounts may have different permissions or access policies. Compare the signed-in accounts in Excel under File > Account, then ask an administrator to review permissions and applicable access policies.

Where can an administrator check unmanaged-device restrictions?

In the SharePoint admin center, open Access control > Unmanaged devices. The administrator can review whether access is limited and change it only if the organization's security policy permits.

How can I tell whether the issue is specific to desktop Excel?

Open the file from its SharePoint library using Open in browser, then try editing and saving it. Compare that result with opening and saving the same file in desktop Excel.

What if the problem occurs in only one SharePoint library?

Ask the library owner or administrator to compare that library's permissions and settings with a library where saving works. Also confirm that the affected user has edit access.

Can WPS Office override a SharePoint access restriction?

No. SharePoint permissions and device-access policies still apply. An administrator must resolve the restriction; WPS can be used to edit compatible spreadsheet files when access is permitted.