File Sharing Problems

Fix Excel Legacy Shared Workbook Unsharing Without Password

Natalie TaylorNatalie Taylor Oct 28, 2026 868 views

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.

Fix Excel Legacy Shared Workbook Unsharing Without 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.
Before you start

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.

Solution 1Recommended

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.

1
Upload to Cloud

Save your Excel workbook to OneDrive, OneDrive for Business, or SharePoint Online.

2
Share the File

Click the 'Share' button in the top-right corner of the Excel window.

3
Set Permissions

Enter the email addresses of your collaborators and set their permissions to 'Can edit' or 'Can view' instead of relying on a workbook password.

Transition to Modern Co-Authoring
Track Changes: Note that the legacy 'Track Changes' feature is not available in co-authoring. You will need to rely on 'Version History' to track modifications.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free suite.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx or .xls files without losing formatting.
  3. 3. Collaborate Securely: Use WPS Cloud to share documents with precise permission controls instead of relying on legacy passwords.
Fully compatible with Microsoft Excel (.xlsx, .xls) and other Office formats.Free and lightweight, avoiding legacy software bugs.Secure cloud collaboration and file sharing capabilities.Familiar user interface requiring zero learning curve.
microsoft office alternative - wps office

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.