Disable AutoSave and Co-Authoring for One SharePoint Excel Workbook
Question details
Allow only one person at a time to edit a macro-enabled Excel workbook stored on SharePoint without removing other users' edit permissions.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Multiple users need access to a SharePoint workbook that contains long-running VBA macros.
- Observed behavior
- AutoSave and co-authoring allow concurrent edits that can interfere with the macros.
Confirm that users open the same SharePoint file and that each intended editor has permission to edit it. Ask the SharePoint administrator whether manual check-out is available for the library, and identify the installed Office version before considering a rollback.
Use SharePoint Check-Out to Coordinate Editing
Use manual check-out as a way to reserve the workbook for one editor when the library supports it.
Check-out requires users to follow a shared procedure; it is not an automatic per-workbook setting that disables AutoSave and guarantees exclusive editing in every client.
Test the procedure with two users before relying on it, including what happens when another user already has the workbook open.
Open the SharePoint document library and select the macro-enabled workbook.
Open the file's More options menu, then choose More > Check out if that command is available.
Open the checked-out workbook in Excel, make the changes, and run the required macros. Ask other users to wait until it is checked in.
Return to the SharePoint library, open the workbook's More options menu, and choose More > Check in so the next editor can work on it.

Turn Off AutoSave in Excel Without Changing Permissions
Use this setting if reducing automatic saves is useful, but do not rely on it to prevent concurrent editing.
Have an Administrator Evaluate an Office Version Rollback
Consider a rollback only if the organization accepts the compatibility and security implications of an older Office build.
Work With Excel Files Using WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents. Open compatible Excel files in WPS Spreadsheets to make migration easier; it does not change Microsoft Excel or SharePoint co-authoring settings.

Frequently Asked Questions
Can I disable AutoSave for this workbook and still prevent everyone else from editing it?
Turning off AutoSave does not prevent co-authoring. Excel does not provide a reliable per-workbook setting that both disables AutoSave and restores exclusive editing for a SharePoint file.
Will SharePoint check-out automatically give me exclusive access?
Manual check-out can help reserve a file for one editor, but users must follow the process. Test it with your library settings and Excel clients, especially when another user already has the file open.
Can I keep all users' edit permissions while coordinating one editor at a time?
Users can retain edit permissions and take turns checking out the workbook from its SharePoint More options menu. This relies on coordination and is not the same as an automatic per-workbook exclusive-editing setting.
Does Workbook.UserStatus show everyone who has the workbook open?
No. Workbook.UserStatus does not report users who have the workbook open as read-only, so it should not be used as a complete list of everyone viewing the file.
Will WPS Office fix SharePoint co-authoring in Microsoft Excel?
No. WPS Office is an alternative for compatible Office files; it does not change Excel or SharePoint settings. Test VBA macro support and workbook behavior before moving a macro-dependent workflow.




