File Sharing Problems

Can You Co-Author Password-Protected Excel Files? Solutions & Alternatives

John WilsonJohn Wilson Oct 21, 2026 870 views

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.

How to Co-Author Secure and Password-Protected Excel Files
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.
Before you start

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.

Solution 1Recommended

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.

1
Remove the password

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.

2
Save to the cloud

Ensure the file is saved and synced to your OneDrive or SharePoint library.

3
Configure specific access

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.

4
Test co-authoring

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 Cloud Permissions Instead of File Encryption
Advanced Security: If your organization has Microsoft 365 Enterprise, you can apply Microsoft Purview sensitivity labels to encrypt files while still allowing co-authoring for authorized users.
Free Microsoft Office alternative

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. 1. Open your spreadsheet: Launch WPS Office and open your .xlsx file.
  2. 2. Click Share: Click the 'Share' button in the top right corner of the application interface.
  3. 3. Set permissions: Adjust the settings to restrict access only to designated team members.
Excellent compatibility with Microsoft Excel (.xlsx) formatsBuilt-in cloud sharing with granular permission controlsLightweight and fast performance on all operating systemsFamiliar user interface makes team migration seamless
microsoft office alternative - wps office

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.