Data Protection Issues

Excel Shared Workbook Protection: Can It Be Bypassed Without a Password?

Khadija KhanKhadija Khan Nov 13, 2026 868 views

Question details

The user needs to know whether Excel's legacy Protect and Share Workbook protection can be bypassed and what safer collaboration control to use instead.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to protect shared workbook changes and prevent collaborators from removing sharing protection without permission.
Observed behavior
In the legacy shared workbook feature, selecting Unshare Workbook can remove sharing protection without requiring the password.
Before you start

Open the workbook in Excel and check whether the Review tab shows Protect and Share Workbook or Unshare Workbook; this confirms that you are using the legacy shared workbook feature.

Solution 1Recommended

Move the workbook to SharePoint or OneDrive co-authoring

Use this for stronger collaboration controls because file access is managed by cloud permissions rather than the legacy shared workbook password.

The legacy Protect and Share Workbook option is not a security boundary. Modern co-authoring stores one cloud copy and uses SharePoint or OneDrive identities to control who can edit, share, or remove access.

1
Save the workbook to a cloud location

In Excel, click File > Save As, choose a SharePoint site or OneDrive location, and save a copy of the workbook.

2
Share with controlled permissions

Click File > Share, enter collaborator email addresses or create a sharing link, and set permissions such as Can edit or Can review.

3
Manage access from the cloud platform

Open SharePoint or OneDrive in a browser, select the file, and use Manage Access to add or remove people instead of relying on Unshare Workbook.

Move the workbook to SharePoint or OneDrive co-authoring
Stronger collaboration protection: Co-authoring permissions are enforced by the cloud service, so removing sharing protection is not controlled solely from Excel's legacy Unshare Workbook command.
Free Microsoft Office alternative

Use WPS Office as a free, lightweight Excel alternative for safer file sharing workflows

WPS Office gives you a familiar spreadsheet experience and opens Excel files with high compatibility. For protection, move away from Excel's legacy shared workbook password and manage file access through your cloud or shared folder permissions.

  1. 1. Download WPS Office: Go to the official WPS Office download page and install the free version for your device.
  2. 2. Open the Excel workbook in WPS Spreadsheets: Launch WPS Office, click Spreadsheets, and open the .xlsx workbook to continue editing with familiar tools.
  3. 3. Use cloud or shared folder permissions for collaboration: Save the file back to OneDrive, SharePoint, or a managed shared folder and set sharing permissions there instead of relying on legacy workbook protection.
Free spreadsheet editor with an Excel-like ribbon and familiar formulasOpens and saves .xlsx, .xls, and .csv files for Microsoft Excel compatibilityLightweight and easy to use on Windows, macOS, and mobile devicesWorks with files stored in OneDrive, SharePoint, or local shared foldersAvoids reliance on Excel's legacy Protect and Share Workbook password bypass
microsoft office alternative - wps office

Frequently Asked Questions

Can someone unshare a protected Excel workbook without the password?

Yes. With the legacy Protect and Share Workbook feature, a user can often go to the Review tab and select Unshare Workbook without entering the password, so it should not be treated as a security control.

Where is the Unshare Workbook button in Excel?

It appears on the Review tab when a workbook has been shared using the legacy Shared Workbook feature. In affected versions, clicking it removes sharing without a password prompt.

What should I use instead of Protect and Share Workbook?

Use modern co-authoring with SharePoint or OneDrive. Save the workbook to a cloud library, select File > Share, and set edit or review permissions for each collaborator.

Is Excel co-authoring safer than legacy shared workbook protection?

Yes. Co-authoring relies on cloud identity and file permissions managed by SharePoint or OneDrive, which are stronger than a workbook-level sharing flag that can be removed without a password.

Can WPS Office open a legacy shared workbook?

WPS Spreadsheets can open Excel workbooks, but because legacy shared workbook protection is an Excel-specific feature, do not rely on it as a security boundary. Open the file and manage access through cloud or shared folder permissions.