SharePoint Document Issues

Fix SharePoint Excel Files Opening as Read-Only or Not Refreshing

Huma Ashraf Ch Sep 30, 2026 869 views

Question details

Users need to resolve an issue where Excel workbooks stored in SharePoint cannot be edited or synced properly.

Fix SharePoint Excel Files Opening as Read-Only or Not Refreshing

Product: Microsoft Excel and SharePoint
Device & OS: not provided
Scenario: Collaborating on shared Excel workbooks stored in a synchronized SharePoint library, particularly when files contain macros.
Observed behavior: Excel files open in read-only mode, fail to display updates from other editors, or remain locked due to editing conflicts and stale sessions.

Before you start

Verify that your internet connection is stable and ensure that your OneDrive desktop sync client is running and up to date without any paused syncing.

Solution 1Recommended

Check Library Checkout Settings and Clear File Locks

Identify if the file is manually checked out by another user or locked due to a stale server session.

SharePoint libraries can be configured to require manual checkouts, preventing others from editing the file simultaneously. Additionally, if a user's session ends abruptly, SharePoint might retain a 'stale lock' on the file.

Access the SharePoint Library

Open your web browser and navigate to the SharePoint document library where the Excel file is stored.

Check for Manual Checkout

Look for a small arrow icon on the Excel file, which indicates it is checked out. If it is, contact the user to check it back in, or have an administrator discard the checkout via the file's ellipsis (...) menu.

Wait for Stale Locks to Expire

If no one is actively editing the file but it still says 'locked for editing', wait approximately 15 to 30 minutes for the server to automatically release the stale lock.

Check Library Checkout Settings and Clear File Locks

Administrator Override: SharePoint administrators can force unlock files by managing checked-out files in the Library Settings.

Solution 2

Address Co-authoring Limitations with Macros

Co-authoring may fail or force read-only mode if the workbook contains macros (.xlsm) and users are on unsupported Excel versions.

Solution 3

Resolve Local Synchronization Conflicts

Fix issues where the local OneDrive sync client has pending conflicts preventing the Excel file from refreshing.

Free Microsoft Office alternative

Switch to WPS Office for Seamless Collaboration

If you frequently struggle with SharePoint file locks and Excel sync conflicts, consider switching to WPS Office. It provides a highly compatible, lightweight alternative with robust cloud collaboration features that prevent locking issues.

1. Download and Install WPS Office: Visit the official WPS website, download the free installer, and complete the quick installation process.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx or .xlsm files directly.
3. Collaborate via WPS Cloud: Save your document to WPS Cloud to instantly share links and co-edit with your team in real-time.

Fully compatible with Microsoft Excel formats, including .xlsx, .xlsm, and .csv.Built-in WPS Cloud allows seamless file sharing and real-time co-authoring without stale locks.Free and lightweight alternative that installs quickly on Windows, Mac, and Linux.Familiar user interface ensures a smooth transition with zero learning curve.

Frequently Asked Questions

Why does my SharePoint Excel file say 'locked for editing' when no one is in it?

This is typically caused by a 'stale lock'. If a user's Excel application crashes, closes improperly, or loses internet connection, the SharePoint server may still perceive the file as open. This lock usually clears automatically after 15 to 30 minutes of inactivity.

Can multiple users co-author a macro-enabled Excel workbook in SharePoint?

Yes, but it requires all users to have a Microsoft 365 subscription with the latest Excel desktop client updates. If any user opens the file with an older, unsupported version of Excel, the file will lock and open as read-only for everyone else.

How do I force unlock an Excel file in SharePoint?

If a file is manually checked out and the user is unavailable, a SharePoint administrator can navigate to the Library Settings, select 'Manage files which have no checked in version', and override the checkout to restore access.

Why are changes made by other users not refreshing in my Excel desktop app?

This can happen if your OneDrive sync client is paused, experiencing a sync conflict, or if you are working offline. Check your OneDrive icon in the system tray to ensure it says 'Up to date' and resolve any pending conflicts.

Document & File Issues