Fix Excel Legacy Shared Workbook Unsharing Without Password
Question details
Users experience an issue where Excel's legacy Protect and Share Workbook feature allows a workbook to be unshared without prompting for the configured password.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to protect a legacy shared workbook with a password to prevent unauthorized users from removing the shared status.
- Observed behavior
- The workbook can be unshared without Excel requesting the password that was originally configured, bypassing the intended security.
Be aware that the 'Protect and Share Workbook' feature is considered a legacy function by Microsoft and has largely been replaced by modern co-authoring tools.
Transition to Modern Co-Authoring
Since the legacy shared workbook feature is being deprecated and has security limitations, switching to modern co-authoring is the recommended approach.
Microsoft has replaced the legacy 'Shared Workbook' feature with real-time co-authoring. Co-authoring relies on cloud storage permissions rather than workbook passwords, providing a more robust and secure way to collaborate.
Save your Excel workbook to OneDrive, OneDrive for Business, or SharePoint Online.
Click the 'Share' button in the top-right corner of the Excel window.
Enter the email addresses of your collaborators and set their permissions to 'Can edit' or 'Can view' instead of relying on a workbook password.

Submit Feedback for Legacy Feature Issues
If your organization relies heavily on the legacy feature and alternative solutions aren't viable, reporting the limitation directly to Microsoft is the official channel for requesting a fix.
Upgrade to WPS Office for Seamless Collaboration
Tired of dealing with legacy feature limitations in Microsoft Excel? WPS Office provides a free, lightweight, and highly compatible alternative. Enjoy a familiar interface that allows you to seamlessly transition your work while maintaining perfect compatibility with your existing Microsoft Office files.
- 1. Download WPS Office: Visit the official WPS website and download the free suite.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx or .xls files without losing formatting.
- 3. Collaborate Securely: Use WPS Cloud to share documents with precise permission controls instead of relying on legacy passwords.

Frequently Asked Questions
Why does Excel allow unsharing without a password?
This is a known limitation in the legacy 'Protect and Share Workbook' feature. As this feature has been deprecated in newer versions in favor of co-authoring, it lacks the strict password enforcement found in modern security protocols.
Can I still use Track Changes in modern Excel co-authoring?
No, the legacy Track Changes feature is not supported in modern co-authoring. Instead, Excel uses 'Version History' to track modifications and view previous iterations of the workbook.
How do I securely share my Excel file without using the legacy feature?
The most secure method is to save your workbook to a cloud service like OneDrive or SharePoint, then use the 'Share' button to grant specific users view or edit permissions.




