Can Password-Protected Excel Workbooks Support Co-Authoring?
Question details
Users want to know if they can simultaneously edit an Excel workbook that is protected with a password.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to collaborate on an encrypted Excel file stored on SharePoint or OneDrive.
- Observed behavior
- The Excel file opens in read-only mode, AutoSave is disabled, and real-time co-authoring is prevented.
Ensure you have the current password for the encrypted Excel workbook and possess edit permissions for the file location on SharePoint or OneDrive.
Remove Password Encryption and Use SharePoint Permissions
Since workbook-level encryption prevents co-authoring, removing the password and restricting access via SharePoint or Microsoft 365 permissions is the officially recommended workaround.
Password protection locks the file structure, preventing Excel's AutoSave and real-time synchronization features from functioning. To enable simultaneous collaboration, you must remove the 'Password to Open' encryption and instead rely on folder or file-level permissions to control who can access the document.
Open the password-protected Excel workbook in the Excel desktop application and enter the current password when prompted.
Click on the 'File' tab in the top-left corner, navigate to 'Info', click the 'Protect Workbook' dropdown menu, and select 'Encrypt with Password'.
In the Encrypt Document dialog box, delete the existing password so the field is entirely blank, then click 'OK'.
Save the workbook to apply the changes. Ensure the file is saved in your SharePoint or OneDrive folder where co-authoring is supported.
Use SharePoint or OneDrive sharing settings to grant access only to authorized users, replacing the need for file-level password encryption.
Experience Seamless Collaboration with WPS Office
If you are struggling with Excel's co-authoring limitations, WPS Office provides a lightweight, highly compatible alternative. Enjoy robust cloud collaboration tools without the heavy subscription fees.
- 1. Download and Install WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing Microsoft Excel workbook seamlessly.
- 3. Collaborate via WPS Cloud: Save the file to WPS Cloud and invite team members to edit the spreadsheet simultaneously in real-time.
Frequently Asked Questions
Why does my shared Excel file open as read-only on SharePoint?
If your Excel workbook is encrypted with a password, SharePoint cannot process real-time synchronization. This forces the file to open in read-only mode to prevent conflicting edits. Removing the password resolves this issue.
Can I password protect a specific sheet while co-authoring?
Yes. While you cannot encrypt the entire workbook with a 'Password to Open', you can protect specific worksheets (Review > Protect Sheet) to restrict editing in certain cells. This allows co-authoring to function while keeping sensitive data untouched.
Will AutoSave work if I re-add the password after editing?
No. Adding a workbook-level password will immediately disable the AutoSave feature and prevent other users from simultaneously co-authoring the document. You will need to remove it again for the next collaboration session.
