Permission & Access Issues

How to Fix Excel Restricted Access Permissions Not Updating

Chanuka GeekiyanageChanuka Geekiyanage Oct 28, 2026 871 views

Question details

The user needs to resolve an issue where Excel's Restricted Access permissions do not update when changing a user's access level.

How to Fix Excel Restricted Access Permissions Not Updating
Product
Microsoft Excel
Device & OS
not provided
Scenario
Modifying a user's workbook permissions from Read Only to Full Control using Information Rights Management.
Observed behavior
The permissions interface shows the updated access level, but the saved workbook still applies the old permission restrictions to the user.
Before you start

Ensure you have the necessary administrative or owner rights to the workbook and verify that your Microsoft 365 subscription is active and connected to the internet.

Solution 1Recommended

Remove and Reconfigure Restricted Access Completely

Since simply changing the permission level fails to apply, completely removing the restriction and setting it up from scratch serves as the most effective workaround.

This behavior is a known synchronization glitch in certain Excel builds where Information Rights Management (IRM) updates fail to commit to the file upon saving.

1
Open Workbook Protection Settings

Open your Excel workbook and navigate to the 'File' tab. Select 'Info', click on 'Protect Workbook', and choose 'Restricted Access'.

2
Remove Existing Restrictions

Select 'Unrestricted Access' or completely clear the existing user permissions to remove the faulty Information Rights Management setup. Save the workbook.

3
Reconfigure Permissions

Go back to 'File' > 'Info' > 'Protect Workbook' > 'Restricted Access'. Add the users again and assign them the correct 'Read Only' or 'Full Control' permissions from the beginning, then save.

Remove and Reconfigure Restricted Access Completely
Submit Feedback: If this is a recurring bug, report it to Microsoft by navigating to Help > Feedback or File > Feedback in Excel so the product team can investigate.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you are tired of dealing with permission glitches or expensive subscriptions, WPS Office provides a free, lightweight, and highly compatible alternative. Enjoy a familiar interface and robust spreadsheet protection features without the hassle.

  1. 1. Download and Install: Download WPS Office for free from the official website and launch WPS Spreadsheet.
  2. 2. Open Your File: Open your existing Excel (.xlsx) workbook directly in WPS Office to experience seamless format compatibility.
  3. 3. Apply Document Protection: Navigate to the 'Review' tab and select 'Protect Workbook' to set up new passwords and user restrictions easily.
Highly compatible with Microsoft Excel (.xlsx) formatsFree and lightweight alternative to Microsoft 365Built-in spreadsheet encryption and worksheet protectionFamiliar user interface for a seamless transition
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel permission settings show Full Control but still act as Read Only?

This is a synchronization glitch in some builds of Excel where Information Rights Management (IRM) updates fail to apply upon saving. Removing and re-adding the user from scratch is the standard workaround.

How do I turn off Restricted Access in Excel completely?

Go to File > Info > Protect Workbook > Restricted Access, and check 'Unrestricted Access'. This removes all custom permissions tied to the workbook.

Does repairing Microsoft Office fix permission issues?

An Online Repair can resolve corrupted background services related to IRM and account syncing, which might be preventing your permissions from updating properly.

Where can I report this Excel bug to Microsoft?

You can report reproducible bugs directly to the product team by opening Excel and navigating to File > Feedback or Help > Feedback.