Can You Co-Author Password-Protected Excel Files? Solutions & Alternatives
Question details
Users need to simultaneously collaborate on sensitive Excel files while ensuring unauthorized access is prevented, but applying a file-open password completely breaks real-time co-authoring.

- Product
- Microsoft Excel, OneDrive, SharePoint
- Device & OS
- not provided
- Scenario
- Trying to collaborate on a sensitive document with authorized executives while keeping the file completely secure from unauthorized staff.
- Observed behavior
- Encrypting the workbook with a password disables AutoSave, real-time collaboration, and simultaneous editing, even when the file is stored in OneDrive or SharePoint.
Ensure your Excel file is saved in a supported cloud location like OneDrive or SharePoint, and always back up a copy before modifying encryption or sharing settings.
Use Cloud Permissions Instead of File Encryption
Remove the file-level password to re-enable co-authoring, and rely on OneDrive or SharePoint folder permissions to restrict unauthorized access.
File-level encryption physically locks the file structure, preventing Excel's real-time synchronization engine from functioning. By removing the password and using cloud-based access control, you regain AutoSave and co-authoring capabilities while keeping the data fully secure.
Open the password-protected Excel file. Navigate to File > Info > Protect Workbook > Encrypt with Password. Delete the existing password so the field is blank, and click OK.
Ensure the file is saved and synced to your OneDrive or SharePoint library.
Right-click the file in your cloud drive or SharePoint library and select 'Share'. Click the gear icon or link settings, choose 'Specific people', and enter the email addresses of the executives who need access.
Have multiple authorized users open the file simultaneously via Excel for the web or a supported desktop version to confirm real-time collaboration is working.

Use Sequential Editing for Mandatory Encrypted Files
If your organization mandates file-level passwords and you cannot use cloud permissions alone, utilize the Check Out feature in SharePoint to manage secure, sequential edits.
Try WPS Office for Seamless Document Collaboration
If Microsoft Excel's strict password limitations are slowing down your team's workflow, WPS Office provides a lightweight, highly compatible, and free alternative. Enjoy easy cloud sharing, customizable viewing and editing permissions, and seamless collaboration without the usual technical hurdles.
- 1. Open your spreadsheet: Launch WPS Office and open your .xlsx file.
- 2. Click Share: Click the 'Share' button in the top right corner of the application interface.
- 3. Set permissions: Adjust the settings to restrict access only to designated team members.

Frequently Asked Questions
Why does AutoSave turn off when I password-protect my Excel file?
Password protection (Encrypt with Password) encrypts the entire file structure. Because cloud servers cannot bypass this encryption to read or merge real-time changes from multiple authors, features like AutoSave and simultaneous editing are automatically disabled.
Can I use sheet-level protection instead of a workbook password to keep co-authoring?
Yes. Unlike encrypting the entire workbook, protecting specific sheets or ranges (found under the Review tab > Protect Sheet) does not disable co-authoring. This method allows multiple people to edit the file simultaneously while locking specific formulas, cells, or data ranges from accidental changes.
Is sharing via OneDrive secure enough without a file-level password?
Yes. OneDrive and SharePoint allow you to generate sharing links that only work for specific, authenticated email addresses. This means even if the link is forwarded to an unauthorized person, they will not be able to open the document, providing robust security without breaking real-time collaboration.




