How to Restrict an Excel File to One Authorized Computer
Question details
The user wants to lock an Excel spreadsheet so it can only be opened by the authorized recipient on a specific computer, preventing them from sharing or forwarding it.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Distributing a sensitive Excel file and attempting to prevent the recipient from sharing it with unauthorized users.
- Observed behavior
- Standard password protection allows the recipient to save and share a decrypted copy of the file, failing to bind the document to a single device.
Before exploring restriction options, confirm whether you are operating within a corporate environment with Microsoft 365 Enterprise licenses, as advanced file permission controls require organizational IT infrastructure.
Use Microsoft Purview Information Protection (Azure RMS)
For corporate environments, apply advanced Information Rights Management (IRM) to prevent forwarding, copying, or printing of the Excel file.
Excel cannot natively bind a file to a specific physical computer's hardware. However, if you are part of an organization, you can use Information Rights Management (IRM) to restrict what specific authenticated users can do with the file, effectively preventing unauthorized sharing.
Open your Excel workbook, navigate to the 'File' tab in the top-left corner, and select 'Info' from the left-hand menu.
Click on the 'Protect Workbook' button to open the drop-down menu, point to 'Restrict Access', and select 'Restricted Access' (this requires your organization to have a rights management server configured).
In the Permissions dialog box, enter the email addresses of the authorized users in the 'Read' or 'Change' fields. Click 'More Options' to explicitly uncheck abilities like printing, copying content, or forwarding.
Apply Standard Password Protection and Encryption
While it does not lock the file to a specific device, this is the first line of defense against unauthorized initial access for non-enterprise users.
Protect Your Spreadsheets with WPS Office
While binding files to a single physical device requires complex enterprise infrastructure like Azure RMS, WPS Office offers a free, lightweight alternative with robust built-in password encryption and permissions to secure your data effortlessly.
Frequently Asked Questions
Can I lock an Excel file to a specific IP address or MAC address?
No, standard Excel does not support binding a workbook to specific network addresses or hardware identifiers like a MAC address. Access is managed through user authentication rather than physical device identification.
Will password protection stop someone from sharing the data?
No. Once an authorized user enters the password and decrypts the file, they can easily save an unprotected copy, copy the data into a new workbook, or take screenshots to share with unauthorized users.
What is Information Rights Management (IRM) in Excel?
IRM is a corporate security feature that allows content creators to assign granular permissions to specific authenticated users. It restricts actions such as copying, printing, or forwarding the document, even after it has been opened by the authorized user.
