Excel Protected Sheet Allows Editing After Copying File: Fix

You protect an Excel sheet to prevent others from changing formulas or data, but after you copy the file to another location or send it to someone, the protection no longer works and the sheet allows editing. This happens because Excel sheet protection is tied to the workbook file itself and does not travel with the file when it is copied or moved. This article explains why sheet protection fails after copying and provides a reliable fix using workbook structure protection and password rules.

Why Sheet Protection Fails After Copying the File

Excel sheet protection is a per-sheet setting stored inside the workbook file. When you protect a sheet with a password, Excel locks cells, hides formulas, and restricts editing actions. However, this protection is not tied to the file itself. If someone copies the workbook file to another folder, renames it, or opens it on a different computer, the protection remains intact on that file. The problem occurs when the user copies the entire sheet or workbook content to a new, unprotected workbook. They can simply select all cells, copy them, and paste into a blank workbook where no protection exists.

The root cause is that Excel does not prevent the user from copying the protected sheet’s content. Sheet protection only blocks direct editing of cells, not the ability to copy and paste the content elsewhere. Furthermore, if the user opens the copied file and removes the sheet protection (if no password was set, or if they guess the password), they can edit freely. Even with a strong password, the user can still copy the entire sheet to a new workbook by right-clicking the sheet tab and selecting Move or Copy, then choosing a new workbook. This bypasses sheet protection entirely.

Steps to Prevent Editing After Copying the File

To truly prevent editing after the file is copied, you must use a combination of sheet protection, workbook protection, and file-level restrictions. Follow these steps in order.

1. Protect the Sheet with a Password
   Open the workbook. Go to the sheet you want to protect. Click Review > Protect Sheet. In the Protect Sheet dialog, enter a strong password in the Password to unprotect sheet field. Make sure the option Select locked cells and Select unlocked cells are checked if you want users to still view the data. Uncheck all other options like Format cells, Insert rows, or Delete columns. Click OK and re-enter the password to confirm. This prevents direct editing of cells but does not stop copying.
2. Protect the Workbook Structure
   Click Review > Protect Workbook. In the Protect Structure and Windows dialog, check Structure. Enter a password in the Password field. This prevents users from moving, copying, deleting, or adding sheets. Even if they right-click the sheet tab, the Move or Copy option will be grayed out. This stops the most common bypass method: copying the sheet to a new workbook.
3. Set a Password to Modify the File
   Click File > Save As. Choose a location and filename. Click Tools (next to the Save button) > General Options. In the General Options dialog, enter a password in the Password to modify field. Click OK, then Save. When someone opens the file, they will be prompted to enter a password to modify it. They can still open the file as read-only, but they cannot save changes to the original file. To copy the content, they would have to open the file as read-only, copy the data, and paste into a new workbook. This adds a layer of friction but does not prevent the copy-paste action entirely.
4. Use Information Rights Management (IRM) for Enterprise Users
   If you have a Microsoft 365 E3 or E5 license, you can apply Information Rights Management. Click File > Info > Protect Workbook > Restrict Access > Restricted Access. In the Permission dialog, set the Read and Change levels. IRM restricts copying, printing, and forwarding at the file level, regardless of where the file is saved. This is the most reliable method for preventing editing after copying, but it requires the recipient to have a Microsoft account and the file to be stored in a supported location like SharePoint or OneDrive.
5. Convert the Sheet to an Image or PDF for Distribution
   If the recipient only needs to view the data and never edit it, convert the sheet to a PDF. Click File > Export > Create PDF/XPS. In the Publish as PDF or XPS dialog, click Options. Under Publish what, select Active sheet(s). Uncheck Document properties and Document structure tags for accessibility. Click OK, then Publish. A PDF cannot be edited in Excel, and most free PDF editors cannot modify the content. This is the simplest way to stop all editing.

What to Do If the Protected Sheet Still Allows Editing After Copying

You Forgot to Protect the Workbook Structure

If you only protected the sheet and not the workbook structure, the user can right-click the sheet tab and choose Move or Copy. In the Move or Copy dialog, they select (new book) from the To book dropdown and check Create a copy. This creates a new workbook with the same sheet but without any sheet protection. The new workbook has no protection, so the user can edit freely. To fix this, go back to the original workbook, click Review > Protect Workbook, and set a password for Structure. Then re-save the file and distribute the new version.

The User Opened the File as Read-Only and Copied the Data

Even with a Password to modify, the user can click Read Only when prompted. They can then select all cells, press Ctrl+C, open a new workbook, and press Ctrl+V. The pasted data is not protected. To prevent this, you must either use IRM or convert the file to PDF. If you cannot use IRM, the only way to stop copy-paste is to use a third-party digital rights management tool or to distribute the file as a PDF.

The Sheet Protection Password Was Removed

If you set a weak password or no password, the user can unprotect the sheet by clicking Review > Unprotect Sheet. Without a password, the sheet is unprotected instantly. With a weak password, the user can use online password recovery tools to remove protection. Always use a strong password with at least 12 characters including uppercase, lowercase, numbers, and special characters. Do not reuse passwords from other systems.

Protection Method	Effectiveness After Copying	Limitation
Sheet Protection Only	Low	User can copy the sheet to a new workbook or remove password if weak
Sheet + Workbook Structure Protection	Medium	User can still copy cells manually and paste into a new workbook
Password to Modify File	Medium	User can open as read-only and copy data
Information Rights Management (IRM)	High	Requires Microsoft 365 E3/E5 license and account for recipient
Convert to PDF	Very High	Recipient cannot edit data at all

Excel sheet protection alone is not enough to prevent editing after the file is copied. You must layer workbook structure protection and file-level passwords to stop the most common bypass methods. For complete security, use IRM or convert the sheet to PDF. Apply all three protection methods in the original workbook before distributing the file to ensure that even if the file is copied, the content remains locked.

After setting up these protections, test the file by opening it on a different computer and attempting to copy the sheet. If the Move or Copy option is grayed out and the user cannot save changes without a password, the protections are working. For advanced scenarios, consider using Excel’s Digital Signature feature to detect if the file has been tampered with after copying.