Disable Real-Time Co-Authoring for Excel Files in OneDrive
Question details
The user wants to prevent simultaneous editing of a shared Excel file stored in OneDrive or SharePoint Online.

- 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.
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.
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.
In SharePoint, open the document library containing the Excel workbook.
Select the workbook, open the three-dot menu, and choose More > Check out.
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.

Work from Separate Copies of the Excel Workbook
Use separate copies when check-out is unavailable or when editors need to work independently.
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.

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.




