Data Protection Issues

Protect an Excel Workbook from Unauthorized Copying

Muhammad TalhaMuhammad Talha Nov 18, 2026 868 views

Question details

The user wants clinic staff to add data to a shared Excel workbook while discouraging unauthorized use at another clinic.

Protect an Excel Workbook from Unauthorized Copying
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.
Before you start

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.

Solution 1Recommended

Restrict Excel Workbook Access with IRM

Use IRM to grant authorized staff access and apply available restrictions to the workbook itself.

1
Open the workbook

Open the workbook in Excel and sign in with your organization's account.

2
Open access settings

Select File > Info > Protect Workbook > Restrict Access. If the option is unavailable, ask your Microsoft 365 administrator whether IRM is configured for your organization.

3
Assign permissions

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.

4
Save and test

Save the workbook, then have an authorized staff member open it and enter test data. Verify that the permissions and restrictions work as intended.

Restrict Excel Workbook Access with IRM
Protection has limits: IRM and workbook permissions cannot guarantee that information will never be copied, photographed, or re-entered elsewhere. Available restrictions depend on your organization's configuration.
Free Microsoft Office alternative

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.

Edit and enter data in shared spreadsheets using a familiar interfaceCompatible with common Microsoft Excel formats, including XLSX and XLSFree and lightweight for everyday office workOpen existing Office files without rebuilding them from scratch
microsoft office alternative - wps office

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.