Protect an Excel Workbook from Unauthorized Copying
Question details
The user wants clinic staff to add data to a shared Excel workbook while discouraging unauthorized use at another clinic.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A dental clinic shares a workbook with staff who need permission to enter data.
- Observed behavior
- Staff need editing access, but the clinic wants to limit who can copy or use the workbook elsewhere.
Check whether your organization has Microsoft Information Rights Management (IRM) configured and which staff accounts need editing access. If the workbook contains patient information, follow your clinic's privacy and approved storage policies.
Restrict Excel Workbook Access with IRM
Use IRM to grant authorized staff access and apply available restrictions to the workbook itself.
Open the workbook in Excel and sign in with your organization's account.
Select File > Info > Protect Workbook > Restrict Access. If the option is unavailable, ask your Microsoft 365 administrator whether IRM is configured for your organization.
Choose the available restricted-access option and add authorized staff accounts. Give staff who must enter data permission to edit, and apply any available restrictions on copying or printing.
Save the workbook, then have an authorized staff member open it and enter test data. Verify that the permissions and restrictions work as intended.

Share the Workbook from a Controlled Location
Use SharePoint, OneDrive, or a secured network location to limit access to approved clinic staff.
Edit Excel Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easy to move existing files. It does not replace Microsoft IRM or guarantee protection against copying.

Frequently Asked Questions
Can I let staff edit an Excel workbook while restricting access?
Yes. In Excel, go to File > Info > Protect Workbook > Restrict Access and grant authorized staff editing permissions, provided your organization supports IRM.
Why is Restrict Access unavailable in Excel?
IRM may not be configured or available for your account. Sign in with your organization's account and ask your Microsoft 365 administrator about IRM availability and permissions.
Does protecting a worksheet stop someone from copying the file?
No. Worksheet and workbook protection are primarily intended to limit changes to cells or workbook structure. Use IRM and controlled storage to restrict access, while recognizing that no method is completely copy-proof.
Can I stop a staff member from using workbook information elsewhere?
You can reduce the risk by restricting access through IRM and approved storage, but an authorized user may still be able to photograph or re-enter information. Combine technical controls with your clinic's privacy policies.




