File Sharing Problems

Fix an Excel 2016 Shared Workbook Opening as Read-Only

Emma BrownEmma Brown Nov 14, 2026 869 views

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.

Fix an Excel 2016 Shared Workbook Opening as Read-Only
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.
Before you start

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.

Solution 1Recommended

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.

1
Check workbook sharing

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.

2
Verify the shared location

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.

3
Check access permissions

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.

4
Test with another user

Save the workbook, then ask another user to open it from the shared folder and check whether editing is available.

Check legacy sharing and folder permissions
Legacy sharing limitations: Legacy shared workbooks have feature limitations, and the Share Workbook command may not be available on the ribbon in every Excel configuration.
Free Microsoft Office alternative

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.

Open and edit Excel-compatible XLS and XLSX workbooksUse a familiar spreadsheet interface for everyday editingMove existing Microsoft Office files into a lightweight office suiteAccess spreadsheet, document, and presentation tools in one application
microsoft office alternative - wps office

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.