'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Stop Multiple Users from Editing an Excel Workbook Simultaneously
Question details
The user wants to prevent multiple users from simultaneously editing an Excel workbook stored on a network drive.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Managing file permissions and preventing simultaneous modifications on a network-stored Excel file.
- Observed behavior
- Multiple users are able to edit the workbook at the same time without triggering a read-only prompt, likely due to legacy shared workbook settings.
Ensure you have the necessary network permissions to modify the file settings, and ask all other users to close the workbook before you proceed.
Disable the Legacy Shared Workbook Feature
Access Excel's hidden legacy Shared Workbook settings to turn off the simultaneous sharing option that allows multiple users to edit the file.
In newer versions of Excel, the traditional 'Shared Workbook' feature is hidden by default but might still be active on older files. You need to add the command to your Quick Access Toolbar to disable it.
Open Excel, click on 'File', and select 'Options'. Go to the 'Quick Access Toolbar' tab. In the 'Choose commands from' dropdown, select 'All Commands'. Scroll down, select 'Share Workbook (Legacy)', and click 'Add', then 'OK'.
Click the newly added 'Share Workbook' icon located at the top left of your Excel window in the Quick Access Toolbar.
In the dialog box, go to the 'Editing' tab. Uncheck the box that says 'Use the old shared workbooks feature to co-author a workbook'. Click 'OK' to save your changes.
Copy Data to a New Blank Workbook
If disabling the sharing feature does not resolve the issue for a specific file, recreating the workbook can clear any corrupted sharing properties.
Manage Your Spreadsheets Securely with WPS Office
If Excel's legacy sharing settings are causing version control issues on your network, try WPS Office. It provides robust file locking by default for network files, ensures full format compatibility, and is completely free to use.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your computer.
- 2. Open Your Network File: Launch WPS Spreadsheet and navigate to your network drive to open your .xlsx file.
- 3. Enjoy Secure File Management: WPS Office automatically manages read and write access, ensuring that secondary users are appropriately restricted to read-only mode.
Frequently Asked Questions
Why is Excel allowing simultaneous editing even when not shared on SharePoint?
Excel's legacy 'Shared Workbook' feature might have been enabled for that specific file in the past. Even if it's stored on a standard network drive instead of SharePoint, this legacy feature allows multiple network users to edit it at the same time.
How do I find the legacy Shared Workbook feature in newer versions of Excel?
Newer versions of Microsoft Excel hide this legacy feature to encourage co-authoring via OneDrive or SharePoint. You can access it by going to File > Options > Quick Access Toolbar, selecting 'All Commands', and manually adding 'Share Workbook (Legacy)'.
Will copying the sheets to a new workbook remove the sharing settings?
Yes, copying worksheets to a brand new, blank workbook typically leaves behind any legacy sharing properties and background file corruption, effectively resetting the file's network sharing state.
Does turning off workbook sharing delete the file's version history?
Yes, disabling the legacy Shared Workbook feature will erase the specific change history associated with that localized sharing session. You should save a backup copy if you need to retain this historical data.
