How to Remove IRM Protection from an Excel File in SharePoint
Question details
The user needs to remove Information Rights Management (IRM) protection from a specific Excel workbook stored in a SharePoint document library.
- Product
- Microsoft SharePoint and Excel
- Device & OS
- not provided
- Scenario
- Managing file access restrictions and attempting to unprotect a single Excel file inside an IRM-enabled SharePoint document library.
- Observed behavior
- The Excel file remains restricted by IRM policies despite the user having full library permissions, because the protection is enforced at the library level rather than the individual file level.
Verify your current SharePoint permission level to confirm whether you have Site Owner or Full Control rights to manage Library Settings and Information Rights Management.
Move or Download the File Outside the Protected Library
Since IRM settings apply uniformly to all supported files within a protected SharePoint library, the most effective way to remove restrictions from a single file is to relocate it to a library or folder where IRM is not enforced.
Information Rights Management (IRM) in SharePoint operates at the document library level. This means it is impossible to exclude a single Excel file from the protection policies as long as it resides in that specific library.
Navigate to your SharePoint document library and locate the specific Excel file you wish to unprotect.
Select the file, click the 'Show Actions' (three dots) icon, and choose 'Download' to save it to your local drive.
Alternatively, use the 'Move to' function to transfer the file to another SharePoint library that does not have IRM policies enabled.
Modify the Library IRM Settings
If the file must remain in its current location, you will need to review the IRM issuance licenses or adjust the library's overall IRM policy to grant appropriate access.
Manage Spreadsheet Security Locally with WPS Office
If managing SharePoint's complex server-level IRM settings is too restrictive, consider using WPS Office for local file management. WPS Office provides robust, file-level password encryption that is easy to control and highly compatible with Microsoft Excel formats.
- 1. Install WPS Office: Download and install WPS Office on your PC or mobile device.
- 2. Open your workbook: Open your downloaded Excel workbook in WPS Spreadsheet.
- 3. Manage encryption: Navigate to the 'Review' tab and click 'Encrypt' to manage local file passwords directly without relying on server-level IRM policies.
Frequently Asked Questions
Can I disable IRM for a specific folder within a SharePoint library?
No, SharePoint Information Rights Management is applied strictly at the document library level. It cannot be enabled or disabled for individual folders or files within that library.
Why can't I edit an IRM-protected Excel file even though I have Full Control permissions in SharePoint?
SharePoint permissions dictate your access to the library itself, but IRM policies dictate what actions you can perform with the file. If the IRM issuance license restricts editing, copying, or printing, those rules override your standard SharePoint library permissions.
Does IRM protection stay with the file if I email it as an attachment?
Yes, IRM protection travels with the file. If a user downloads an IRM-protected file and emails it, the recipient will still need to authenticate and have the proper rights defined in the issuance license to open or modify it.
