Fix an Excel 2016 Shared Workbook Opening as Read-Only
Question details
The user needs other users to edit an Excel 2016 shared workbook instead of receiving a read-only or file-in-use message.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- Multiple users need to edit a workbook configured for legacy shared-workbook use.
- Observed behavior
- Excel shows the workbook as shared, but other users are told the file is in use or may open as read-only.
Confirm that everyone is opening the same workbook from a shared location and has permission to modify the file and its folder. Ask users to close their copies before checking for stale lock files.
Check legacy sharing and folder permissions
Use this first to confirm that the workbook is configured for legacy sharing and that other users can edit it.
Open the workbook in Excel 2016 and select Review > Share Workbook. On the Editing tab, check whether changes by more than one user are allowed.
In Excel, select File > Info and check the workbook location. Make sure other users open the same file from the shared network folder rather than a local copy.
In File Explorer, right-click the shared folder and select Properties > Security. Ask the folder administrator to verify that affected users have permission to modify the workbook and folder.
Save the workbook, then ask another user to open it from the shared folder and check whether editing is available.

Update Office and disable File Explorer preview panes
Use these checks to address outdated software or preview panes that may keep a workbook in use.
Remove a stale lock file and check for service conflicts
Use this when the workbook still appears to be in use after everyone has closed it.
Edit Excel-Compatible Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easier to move existing files. It does not repair Excel's legacy shared-workbook locking issue.

Frequently Asked Questions
Why does a shared workbook still open as read-only?
Legacy sharing may be enabled, but folder permissions, a stale owner file, a preview pane, or another process can still interfere with access. Check Review > Share Workbook and the shared folder's permissions first.
How do I turn off the Preview pane in Windows?
Open File Explorer, select View, and turn off Preview pane. Turn off Details pane there as well, then reopen the workbook in Excel.
Can I delete the file that starts with ~$?
A matching ~$ owner file may be removed if it remains after everyone has saved and closed the workbook and no process is using it. Do not delete the workbook itself.
Should I change OpLocks registry settings?
Only an administrator should evaluate that option. OpLocks settings depend on the network environment, and changing them without checking the configuration can affect other applications.




