License & Subscription Issues

Fix Restrict Access Missing from Excel Protect Workbook

John WilsonJohn Wilson Oct 16, 2026 868 views

Question details

Users are unable to locate the Restrict Access option within the Excel Protect Workbook menu.

How to Fix Restrict Access Missing from Excel Protect Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to secure sensitive spreadsheet data using the Restrict Access feature under the Protect Workbook menu.
Observed behavior
The Restrict Access option is missing from the File > Info > Protect Workbook menu in Excel version 2302.
Before you start

Ensure you have the login credentials for your Microsoft 365 admin account, as you may need to verify your organization's subscription details and Information Rights Management configurations.

Solution 1Recommended

Verify Information Rights Management (IRM) Subscription

The Restrict Access feature requires an active Information Rights Management (IRM) configuration, which is not included in all Microsoft 365 business plans.

Restrict Access utilizes Information Rights Management (IRM) to prevent unauthorized users from printing, forwarding, or copying sensitive data. If this feature is missing, your current Microsoft 365 plan likely does not support IRM, or your IT administrator has not enabled it for your organization.

1
Contact your IT Administrator

Reach out to your organization's IT administrator to confirm if Information Rights Management is enabled for your Microsoft 365 tenant.

2
Check Microsoft 365 Subscription Plan

Verify that your specific Microsoft 365 Business Apps plan includes IRM support by reviewing the official Microsoft 365 Platform Service Description.

3
Enable IRM in Admin Center

If your subscription supports IRM but it is not active, administrators can configure and enable it through the Microsoft Purview compliance portal.

Verify Information Rights Management (IRM) Subscription
Admin Access Required: Only Microsoft 365 administrators can enable or purchase add-ons for Information Rights Management at the organization level.
Free Microsoft Office alternative

Secure Your Spreadsheets Easily with WPS Office

If your Microsoft 365 subscription does not include expensive Information Rights Management features, WPS Office offers a powerful, lightweight, and free alternative. Enjoy full format compatibility and built-in document encryption to keep your data safe.

  1. 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing Excel workbook without losing any formatting.
  3. 3. Encrypt the File: Go to the Menu, select Document Encryption, and apply a secure password to restrict unauthorized access.
100% compatible with Microsoft Office formats, including .xlsx and .xlsFree built-in document encryption and sheet protection featuresLightweight design with a familiar, easy-to-use tabbed interfaceSecurely share files without relying on complex IRM admin settings
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Protect Workbook button greyed out in Excel?

This usually happens if the workbook is marked as final, is currently shared, or if multiple sheets are selected at once. Ungroup your sheets or remove the 'Mark as Final' status to restore access to the protection options.

Can I restrict access to an Excel file without Information Rights Management (IRM)?

Yes. You can use standard password encryption by navigating to File > Info > Protect Workbook > Encrypt with Password. This requires users to enter a password to open the document, though it lacks the granular user-specific permissions of IRM.

What does Information Rights Management (IRM) do in Excel?

IRM allows document creators to specify exactly who can access a document and what actions they can perform, such as restricting users from printing, copying, or forwarding the workbook to unauthorized individuals.

How do I check my current Microsoft 365 subscription plan?

You can view your current subscription by opening Excel, clicking on File, and selecting Account. Your specific subscription product and version details will be listed under the Product Information section.