File Sharing Problems

Disable Real-Time Co-Authoring for Excel Files in OneDrive

Steve KSteve K Nov 14, 2026 868 views

Question details

The user wants to prevent simultaneous editing of a shared Excel file stored in OneDrive or SharePoint Online.

Can You Disable Real-Time Co-Authoring for Excel Files in OneDrive?
Product
Microsoft Excel for Microsoft 365, OneDrive, and SharePoint Online
Device & OS
not provided
Scenario
A shared Excel workbook is stored in OneDrive or a SharePoint document library, and the user wants one person to edit it at a time.
Observed behavior
Microsoft 365 does not offer a general setting to turn off real-time co-authoring for a shared Excel file.
Before you start

Check whether the workbook is in a SharePoint document library and whether you have permission to check it out. Ask other editors to close the workbook before you begin.

Solution 1Recommended

Check Out the Workbook in a SharePoint Document Library

Use check-out to prevent other users from editing the workbook while it is checked out to you.

Check-out is available in SharePoint document libraries. Availability and menu options may differ in OneDrive, so use the separate-copies workaround if check-out is not offered.

1
Open the library

In SharePoint, open the document library containing the Excel workbook.

2
Check out the file

Select the workbook, open the three-dot menu, and choose More > Check out.

3
Edit and check in

Open and edit the workbook. When you are finished, return to the library, open the file's three-dot menu, and choose More > Check in so others can access your changes.

Check Out the Workbook in a SharePoint Document Library
Require check-out for a library: A library administrator can require check-out in Library settings > Versioning settings. This setting applies to the library, not just one workbook, and is not enabled by default.
Free Microsoft Office alternative

Edit Separate Excel Workbook Copies with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easy to move existing workbooks into a separate-copy workflow. It does not change Microsoft 365 co-authoring settings.

Edit separate workbook copies without relying on Excel co-authoringOpen and save Microsoft Excel formats such as XLSX and XLSWork in a familiar, easy-to-use spreadsheet interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Is there a Microsoft 365 setting to turn off Excel co-authoring everywhere?

No general setting is available to disable real-time co-authoring for shared Excel files in OneDrive or SharePoint Online. You can use SharePoint check-out where available or work from separate copies.

How do I check out an Excel file in SharePoint?

Open the SharePoint document library, select the workbook, and choose More > Check out from its three-dot menu. Check the file back in from the same menu when you finish editing.

Does turning off AutoSave disable co-authoring?

No. Turning off AutoSave is not a general co-authoring control and can increase the risk of conflicting changes. Use check-out or separate copies instead.

Can I request a permanent co-authoring control from Microsoft?

Yes. In Excel, use Help > Feedback, or submit a request through the Microsoft feedback portal.