How to Fix IRM Protection Applied to One Excel File in SharePoint
Question details
A single Excel file is restricted by Information Rights Management (IRM) after being uploaded to SharePoint, preventing users from opening it in the browser.
- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- Uploading an Excel workbook to a SharePoint library where IRM protection is completely disabled at the library level.
- Observed behavior
- Despite library settings, the uploaded Excel file becomes IRM-protected, restricting access and preventing the file from opening in the web browser.
Verify your SharePoint library settings by going to Library Settings > Information Rights Management to confirm that IRM is completely disabled for the entire library.
Copy Content to a New Excel Workbook
Because IRM is applied at the library level and not at the individual file level, creating a fresh workbook strips away any unexpected backend permissions attached to the original file.
According to Microsoft documentation, IRM protection is designed to operate at the list and library level. When a single file triggers this restriction, it is usually due to metadata corruption or an inherited property glitch within that specific workbook.
Open the affected Excel workbook using the Excel desktop application where you have permissions to view it.
Go to File > New and select 'Blank workbook' to open a completely fresh file.
Highlight the data in your original file, copy it (Ctrl+C), and paste it (Ctrl+V) into the new blank workbook. Consider using 'Paste Values' if you want to ensure no hidden properties carry over.
Save the newly created workbook with a new name and upload it to the SharePoint library to verify the IRM protection is gone.
Escalate to Microsoft 365 Support
If the new file also gets restricted, the issue lies within the SharePoint backend synchronization and requires an administrator to intervene.
Try WPS Office for Seamless Spreadsheet Management
If you are tired of dealing with complex Microsoft Office backend glitches and unexpected file restrictions, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for everyday spreadsheet tasks without the hassle.
- 1. Download the software: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Install and launch: Run the installer, complete the quick setup, and open WPS Spreadsheets.
- 3. Edit files easily: Open your existing .xlsx files directly in WPS to edit, save, and manage your data with complete format preservation.
Frequently Asked Questions
Can Information Rights Management (IRM) be enabled on just a single file in SharePoint?
No. By default, SharePoint applies Information Rights Management at the document library or list level. It is not designed to be toggled on or off for individual files or folders. If a single file shows IRM protection, it is usually due to a file glitch or inherited permissions from a previous location.
Why does my Excel file say it cannot be opened in the browser due to IRM?
IRM protection encrypts the document to prevent unauthorized printing, copying, or forwarding. Excel for the Web often cannot process this encryption dynamically in the browser, which is why it prompts you to open the document using the full desktop application to verify your credentials.
How do I check if my SharePoint library has IRM enabled?
Navigate to the SharePoint library, click the Settings gear icon in the top right, and select 'Library settings'. Click on 'More library settings', then look for 'Information Rights Management' under the Permissions and Management column to view its status.
