File Sharing Problems

How to Unshare a Workbook in Excel When the Option Is Disabled

Khadija Khan Oct 12, 2026 868 views

Question details

The user needs to unshare an Excel spreadsheet but finds that the standard 'Unshare Workbook' option is greyed out or unavailable.

How to Unshare an Excel Workbook When the Option Is Disabled

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to revoke sharing access for an Excel file that is hosted on cloud services such as OneDrive or SharePoint.
Observed behavior: The traditional legacy 'Unshare Workbook' command is disabled because the file relies on modern cloud co-authoring instead of legacy sharing.

Before you start

Verify where your Excel file is saved (local drive, OneDrive, or SharePoint) and ensure you have owner or edit permissions for the file before attempting to change its sharing settings.

Solution 1Recommended

Stop Sharing via the Modern Manage Access Menu

Use this method if your Excel file is stored in OneDrive or SharePoint and relies on modern cloud co-authoring rather than the legacy shared workbook feature.

When an Excel workbook is saved to Microsoft's cloud services, the legacy 'Share Workbook' feature is replaced by modern co-authoring. Consequently, the old 'Unshare Workbook' button becomes disabled. You must manage permissions through the modern Share pane instead.

Open the Share pane

In the upper-right corner of the Excel window, click on the 'Share' button.

Access sharing settings

At the bottom of the Share dropdown menu, select 'Manage Access'. Alternatively, click the three-dot menu icon in the Share panel and choose Manage Access.

Stop sharing completely

Click 'Stop sharing' at the top of the Manage Access dialog box to revoke access for everyone except the owner. To remove specific individuals, click the dropdown next to a user's name and select 'Remove'.

Stop Sharing via the Modern Manage Access Menu

Permission Requirements: You must be the file owner or have sufficient administrative rights over the OneDrive or SharePoint folder to modify sharing permissions.

Solution 2

Remove Legacy Shared Workbook Protection

If the file is stored locally and still uses the older shared workbook feature but the unshare option is greyed out, it may be protected with a password.

Free Microsoft Office alternative

Use WPS Office for Hassle-Free Spreadsheet Sharing

If navigating complex Microsoft Excel sharing permissions and disabled legacy buttons is slowing your workflow, consider switching to WPS Office. It provides a unified, intuitive interface for managing local and cloud files without feature confusion.

1. Download and install: Download WPS Office for free from the official website and install it on your device.
2. Open your spreadsheet: Launch WPS Spreadsheet and easily open your existing Excel (.xlsx) files without losing any formatting.
3. Share with ease: Click the 'Share' button in the upper right corner to instantly generate secure links, invite collaborators, or revoke access with a single click.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Simplified file sharing and permission management through built-in WPS Cloud.Free and lightweight alternative with a familiar, easy-to-navigate interface.Seamless migration from Microsoft Office with no learning curve required.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Unshare Workbook button greyed out in Excel?

The button is typically disabled because the file is saved in OneDrive or SharePoint, which uses modern co-authoring instead of the legacy Shared Workbook feature. It can also be greyed out if the worksheet is locked or protected by another user.

How do I know if my Excel file is using modern cloud sharing?

If the AutoSave toggle in the top-left corner of your Excel window is turned on and the file path indicates it is stored in a OneDrive or SharePoint directory, the workbook is using modern cloud co-authoring rather than legacy sharing.

Can I force Excel to use the legacy Shared Workbook feature?

Yes, you can restore the legacy feature by customizing the Quick Access Toolbar. Go to File > Options > Quick Access Toolbar, select 'All Commands' from the dropdown, and add 'Share Workbook (Legacy)' to your toolbar. Note that Microsoft recommends using modern co-authoring instead.

What happens when I click Stop Sharing on an Excel file?

Clicking Stop Sharing immediately revokes access for all invited users. They will no longer be able to view or edit the file, and any active sharing links previously generated for that document will become disabled.

Document & File Issues