Permission & Access Issues

How to Copy Data from a Protected Excel Workbook

Maira Mehtab Sep 20, 2026 868 views

Question details

The user needs to copy data from a protected worksheet into a blank workbook, but the action is blocked by worksheet protection settings.

Product: Excel
Device & OS: not provided
Scenario: Attempting to select and copy cell data from a protected worksheet to paste into a new blank workbook.
Observed behavior: The copying process fails, and Excel displays a prompt stating that the workbook is protected and cannot be changed.

Before you start

Ensure you have the protection password if the worksheet is password-protected, or verify who the document owner is so you can request access if needed.

Solution 1Recommended

Unprotect the Worksheet and Adjust Permissions

If you are the owner or have the password, you can remove the protection to copy your data, and then reapply it with the correct selection settings enabled.

By default, protecting a worksheet without allowing users to select cells will completely block the ability to highlight or copy data. Adjusting the protection permissions solves this.

Unprotect the sheet

Open the protected workbook, navigate to the 'Review' tab on the top ribbon, and click 'Unprotect Sheet'. Enter the password if prompted and click 'OK'.

Copy the required data

Highlight the cells you need, press Ctrl+C to copy the data, and paste it into your new blank workbook.

Re-protect with proper permissions

To secure the sheet again while allowing future copying, click 'Protect Sheet'. In the dialog box, ensure both 'Select locked cells' and 'Select unlocked cells' are checked, then click 'OK'.

Permissions Updated: Checking the cell selection options allows anyone viewing the protected sheet to copy data without altering the original formulas or text.

Solution 2

Request Access from the Document Owner

If you do not have ownership rights or the password to the worksheet, you cannot change the protection settings yourself and must contact the owner.

Manage Spreadsheet Permissions Easily

Edit and Protect Spreadsheets with WPS Office

WPS Office offers intuitive and robust tools for handling spreadsheet permissions. You can easily unprotect sheets, extract the data you need, and reapply password protection with granular permissions like allowing cell selection without risking unauthorized edits.

1. Open the file in WPS Spreadsheet: Launch WPS Office and open your protected spreadsheet.
2. Remove protection: Go to the 'Review' tab, click 'Unprotect Sheet', and enter the password.
3. Copy and paste data: Select the required data, copy it, and paste it into a new WPS Spreadsheet document.
4. Reapply protection: Click 'Protect Sheet' from the 'Review' tab, check 'Select locked cells', and apply a password to secure the file while keeping it copyable.

Easily manage sheet and workbook protection settingsFully compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight, fast, and completely free to useGranular control over cell selection and editing rights

microsoft office alternative - wps office

Frequently Asked Questions

Can I copy data from a protected Excel sheet without the password?

If the sheet is password-protected and the owner disabled the ability to select cells, you cannot copy the data. You must either obtain the password to unprotect it or request the owner to adjust the permissions.

Why is the 'Copy' option grayed out in my Excel workbook?

The 'Copy' option is usually grayed out when worksheet protection is enabled and the 'Select locked cells' and 'Select unlocked cells' permissions are unchecked. Unprotecting the sheet will restore the copying functionality.

How do I allow others to copy data while keeping my Excel sheet protected?

When applying protection via the 'Review' > 'Protect Sheet' menu, make sure to check the boxes for 'Select locked cells' and 'Select unlocked cells' in the permissions list. This allows users to highlight and copy data without altering the spreadsheet.

Document & File Issues