Excel Shared Workbook Opens Read Only for Some Users: Fix

When you share an Excel workbook with colleagues, some users may see the file open as read-only even though others can edit it normally. This problem usually happens because of file-locking conflicts, incorrect sharing settings, or user permission restrictions on the network or cloud location. In this article, you will learn the exact causes of this read-only behavior and the step-by-step fixes to restore full editing access for all users.

Why Excel Opens Shared Workbooks as Read-Only for Some Users

Excel uses a combination of file attributes, user permissions, and internal locking mechanisms to control who can edit a shared workbook. When a user opens a shared workbook, Excel checks for an existing lock file (a hidden file starting with ~$) in the same folder. If another user has the file open, Excel opens the workbook as read-only to prevent conflicts. However, the problem can also occur when no one else has the file open, which points to one of these root causes:

Orphaned Lock Files

If Excel or the computer crashes while a user has the workbook open, the lock file may remain in the folder. When the next user tries to open the workbook, Excel sees the orphaned lock file and assumes the file is still in use. This forces the workbook to open as read-only for that user.

Protected View Settings

Excel’s Protected View feature opens files from untrusted locations such as the internet, email attachments, or network shares in read-only mode. If the shared workbook is stored on a network drive or downloaded from a cloud service, Excel may treat it as untrusted and block editing.

File Permissions and Sharing Conflicts

When the workbook is stored on SharePoint, OneDrive, or a network folder, each user must have explicit edit permissions. If a user has read-only permissions on the folder or file, Excel will open the workbook as read-only. Additionally, if the file is marked as “Final” or “Read-Only Recommended” in the file properties, Excel will enforce those settings.

Steps to Fix Excel Shared Workbook Opening as Read-Only for Some Users

Follow these steps in order. Test the workbook after each step to see if the issue is resolved for the affected users.

Step 1: Delete Orphaned Lock Files

1. Close Excel completely on all computers
   Make sure no user has the workbook open. Ask each user to close Excel and check Task Manager for any Excel.exe processes still running.
2. Open the folder containing the shared workbook
   Navigate to the network share, SharePoint sync folder, or local folder where the workbook is stored.
3. Enable viewing of hidden files
   In File Explorer, click View > Show > Hidden items. This reveals files starting with ~$.
4. Delete any ~$ files that match your workbook name
   For a workbook named Budget.xlsx, look for a file named ~$udget.xlsx. Select it and press Delete. Also delete any .tmp files with names containing the workbook name.
5. Empty the Recycle Bin
   Right-click the Recycle Bin and select Empty Recycle Bin to ensure the lock files are fully removed.

Step 2: Disable Protected View for Network and Cloud Files

1. Open Excel and go to File > Options
   Select Trust Center, then click Trust Center Settings.
2. Select Protected View on the left
   Uncheck all three boxes:
   • Enable Protected View for files originating from the internet
   • Enable Protected View for files located in potentially unsafe locations
   • Enable Protected View for Outlook attachments
3. Click OK twice
   Close all Excel windows and reopen the shared workbook. Test if it now opens with edit access.

Step 3: Remove Read-Only and Final Markers from the File

1. Open the workbook with a user who has full edit access
   This is usually the owner or creator of the file.
2. Go to File > Info
   Look for the Protect Workbook button. If the file is marked as “Marked as Final” or “Always Open Read-Only,” click the button and select the option to remove the restriction.
3. Check the Read-Only Recommended setting
   Click File > Save As > Browse. In the Save As dialog, click the arrow next to the Save button and select General Options. Under “File sharing options for this workbook,” uncheck “Read-only recommended” if it is checked. Click OK and save the file with a new name, then share the new version.

Step 4: Verify User Permissions on SharePoint or OneDrive

1. Open the file location in a web browser
   Go to the SharePoint site or OneDrive folder where the workbook is stored.
2. Check sharing permissions for each affected user
   Select the workbook, click Share or Manage Access. Ensure every user who needs edit access has at least “Edit” permission, not “View” or “Read.”
3. If users are external (guest), verify their access level
   External users may need explicit edit permissions even if the folder is shared with “Anyone with the link can edit.”

Step 5: Disable the Legacy Shared Workbook Feature if Using Co-authoring

1. Open the workbook in Excel
   Go to Review > Share Workbook (Legacy).
2. Uncheck “Use the old shared workbooks feature instead of the new co-authoring experience”
   If this option is enabled, Excel uses the legacy sharing method, which can cause read-only conflicts with modern co-authoring. Uncheck it and click OK.
3. Save the workbook
   Close and reopen the file. Test with multiple users simultaneously.

If Excel Still Opens the Shared Workbook as Read-Only

If the main fixes above do not resolve the issue, check these additional scenarios.

Excel Opens the Workbook as Read-Only for One Specific User Only

This usually indicates a local Excel setting or a corrupt user profile on that computer. Try the following:

1. Reset Excel settings for that user
   Close Excel. Press Windows+R, type excel /safe and press Enter. If the workbook opens with edit access in Safe Mode, an add-in or custom setting is causing the problem. Disable all add-ins via File > Options > Add-ins > Manage COM Add-ins.
2. Clear the Office cache
   Close all Office apps. Press Windows+R, type %localappdata%\Microsoft\Office\16.0\OfficeFileCache and delete all files in that folder.
3. Repair Office installation
   Go to Settings > Apps > Microsoft 365 > Modify > Quick Repair. If that does not work, try Online Repair.

Excel Opens the Workbook as Read-Only for All Users

If every user sees the workbook as read-only, the problem is likely at the file or folder permission level. Check these items:

1. Verify the file is not checked out in SharePoint
   In the SharePoint library, check if the file shows “Checked Out To” a specific user. If so, the user must check it back in.
2. Remove the Read-Only file attribute
   Right-click the file in File Explorer, select Properties, and uncheck Read-only under Attributes. Click Apply and OK.
3. Ensure the file is not in a folder with restricted permissions
   If the folder itself has read-only permissions for certain users, move the workbook to a different folder with full edit access for everyone.

Quick Repair vs Online Repair: Key Differences

Item	Quick Repair	Online Repair
Description	Repairs Office installation locally without downloading files	Downloads and reinstalls Office from Microsoft servers
Time required	5 to 10 minutes	30 to 60 minutes depending on internet speed
Internet needed	No	Yes
Fixes corrupt user settings	Yes	Yes
Fixes missing Office files	No	Yes

Now you know how to fix an Excel shared workbook that opens as read-only for some users. Start by deleting orphaned lock files and disabling Protected View for network files. If the issue persists, verify user permissions on SharePoint or OneDrive and remove any read-only markers from the file properties. As an advanced tip, configure Excel to always open files from trusted network locations by adding the folder path to File > Options > Trust Center > Trust Center Settings > Trusted Locations.