SharePoint Document Issues

Disable AutoSave and Co-Authoring for One SharePoint Excel Workbook

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 868 views

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.

Disable AutoSave and Co-Authoring for One SharePoint Excel Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Find the workbook

Open the SharePoint document library and select the macro-enabled workbook.

2
Check out the file

Open the file's More options menu, then choose More > Check out if that command is available.

3
Edit and run the macros

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.

4
Check the file back 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.

Use SharePoint Check-Out to Coordinate Editing
Check the library settings: Requiring check-out at the library level can affect other documents. Manual check-out also depends on users checking in the file when they finish.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel formats, including XLSX filesWork with spreadsheet data in a familiar interfaceUse a free, lightweight office suite alongside existing Office workflowsReview macro-enabled workbook compatibility before migrating a VBA workflow
microsoft office alternative - wps office

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.