'%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 Co-Author Password-Protected Excel Workbooks Online
Question details
The user wants to know how to simultaneously co-author an Excel workbook online that is secured with an open or edit password.
- Product
- Microsoft Excel, Excel for the Web, OneDrive
- Device & OS
- not provided
- Scenario
- Attempting to collaborate in real-time on a secure, password-protected Excel spreadsheet stored in OneDrive.
- Observed behavior
- Password-protected files stored in OneDrive cannot be co-authored. Excel for the web allows worksheet protection but does not support desktop-style workbook open or edit passwords.
Check if your Excel workbook is currently protected with an open or modify password from the desktop application, as this encryption prevents online co-authoring.
Use Sharing Permissions and Worksheet Protection
Since workbook-level passwords prevent co-authoring online, you can secure your data by relying on OneDrive access controls and sheet-level protection instead.
There is currently no supported way to combine desktop-style workbook passwords with Excel web co-authoring. To protect your data while collaborating, you must remove the workbook password and use a combination of cloud sharing permissions and worksheet protection.
Open your file in the Excel desktop application. Navigate to File > Info > Protect Workbook > Encrypt with Password. Clear the existing password, click OK, and save the document back to OneDrive.
In your OneDrive or SharePoint online interface, select the Excel file and click Share. Adjust the link settings to restrict access, such as choosing 'Specific people' and unchecking 'Allow editing' for users who only need to view the data.
Open the file in Excel for the web. Go to the Review tab on the ribbon and click Protect Sheet. You can set a password here to restrict specific editing actions on that individual sheet while still allowing simultaneous co-authoring across the workbook.
Collaborate Securely with WPS Office
Looking for a seamless way to manage and share your spreadsheets? WPS Office provides robust document protection, easy cloud sharing, and full compatibility with Microsoft Excel formats—without the heavy subscription fees.
- 1. Download and install: Visit the official WPS website to download and install the free WPS Office suite on your desktop or mobile device.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing Microsoft Excel files with zero formatting loss.
- 3. Share with permissions: Click the Share button in the top right corner to generate secure collaboration links with customized viewing and editing controls.
Frequently Asked Questions
Why does Excel say my file is locked for editing when I try to co-author?
If an Excel file is encrypted with an open or modify password via the desktop app, Excel restricts access to one user at a time to prevent conflicting encrypted changes. You must remove the password to enable co-authoring.
Can I add a workbook password to an Excel file using the web version?
No, Excel for the web does not currently support adding or modifying workbook-level open or edit passwords. You can only protect specific worksheets or rely on OneDrive link sharing permissions for security.
Will Microsoft add co-authoring support for password-protected workbooks in the future?
While Microsoft frequently improves Excel for the web, there is no official timeline or confirmation for achieving feature parity regarding password-protected co-authoring. Users are encouraged to submit feedback to Microsoft.
