Fix Restrict Access Missing from Excel Protect Workbook
Question details
Users are unable to locate the Restrict Access option within the Excel Protect Workbook menu.

- 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.
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.
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.
Reach out to your organization's IT administrator to confirm if Information Rights Management is enabled for your Microsoft 365 tenant.
Verify that your specific Microsoft 365 Business Apps plan includes IRM support by reviewing the official Microsoft 365 Platform Service Description.
If your subscription supports IRM but it is not active, administrators can configure and enable it through the Microsoft Purview compliance portal.

Use Basic Excel Workbook Protection
If IRM is unavailable in your subscription, you can use Excel's built-in password protection as a reliable alternative to secure your data.
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. Install WPS Office: Download and install the free WPS Office suite on your computer.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing Excel workbook without losing any formatting.
- 3. Encrypt the File: Go to the Menu, select Document Encryption, and apply a secure password to restrict unauthorized access.

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.




