Permission & Access Issues

Fix Excel Cell Protection Not Working in SharePoint

John Wilson Sep 25, 2026 869 views

Question details

Worksheet protection and locked cells function correctly in the local Excel file but appear to stop working once the workbook is uploaded to SharePoint for collaboration.

Fix Excel Cell Protection Not Working After Moving to SharePoint

Product: Microsoft Excel
Device & OS: not provided
Scenario: Uploading a locally protected Excel workbook to SharePoint to collaborate with team members.
Observed behavior: Cell-level protection and locked formulas fail to transfer or enforce their restrictions when the file is accessed via SharePoint or Excel for the web.

Before you start

Ensure you have access to the desktop version of Microsoft Excel, as advanced cell-locking configurations must be managed locally before being synced to SharePoint.

Solution 1Recommended

Re-apply Cell Locking and Worksheet Protection in Desktop Excel

Clear all cell locks and re-apply protection from scratch in the desktop application to ensure metadata syncs correctly to SharePoint.

Excel for the Web has limited capabilities when it comes to configuring worksheet protection. To guarantee that cell locks apply correctly online, you must configure all protection settings in the desktop application prior to uploading the file to SharePoint.

Open File Locally

Open your workbook in the desktop Excel application, not in the web browser.

Unlock All Cells

Select the entire worksheet by clicking the triangle in the top-left corner (or pressing Ctrl+A). Right-click any cell, select 'Format Cells', go to the 'Protection' tab, uncheck the 'Locked' box, and click OK.

Lock Specific Cells

Highlight only the specific cells or formulas you want to protect. Right-click the selection, choose 'Format Cells', navigate to the 'Protection' tab, check the 'Locked' box, and click OK.

Protect the Worksheet

Navigate to the 'Review' tab on the ribbon and click 'Protect Sheet'. Choose a password (optional but recommended), confirm the password, and click OK.

Save and Upload

Save your changes and upload or sync the workbook to SharePoint. Open the file in Excel for the web to verify the protection is now active.

Re-apply Cell Locking and Worksheet Protection in Desktop Excel

Verification Step: If the protection works properly, users accessing the file via SharePoint will be unable to edit the locked cells, while remaining free to collaborate on the unlocked areas.

Solution 2

Test Protection Persistence with a Clean Sample File

Determine if the issue is tied to file corruption or your SharePoint environment by testing a brand new, sanitized workbook.

Free Microsoft Office alternative

Secure Your Spreadsheets Easily with WPS Office

If SharePoint and Excel for the Web are causing issues with your worksheet protection, WPS Office offers a highly compatible, lightweight alternative. Enjoy robust cell protection and seamless collaboration natively within WPS Cloud.

1. Download and Install: Get WPS Office for free and install it on your device.
2. Open Your Excel File: Open your existing .xlsx workbook directly in WPS Spreadsheet without losing any formatting.
3. Configure Protection: Navigate to the Review tab to lock specific cells and securely protect your worksheet before sharing via WPS Cloud.

100% compatible with Microsoft Excel (.xlsx) formats and existing worksheet protection rules.Easily lock cells, hide formulas, and protect worksheets securely from a familiar desktop interface.Free and lightweight software that avoids the heavy resource usage of standard Office suites.Built-in WPS Cloud allows for seamless real-time collaboration while preserving your security settings.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel worksheet protection disappear in SharePoint?

This usually happens because Excel for the Web does not fully support configuring protection rules directly in the browser. If the file is uploaded without properly applying cell locks in the desktop application first, or if the file contains legacy XML corruption, SharePoint may fail to enforce the protection.

Can I lock specific cells in Excel for the Web?

While Excel for the Web respects worksheet protection applied in the desktop version, you cannot fully configure which individual cells are locked or unlocked directly through the web interface. You must click 'Open in Desktop App' to modify these specific restrictions.

Does co-authoring in SharePoint affect cell protection?

Co-authoring is supported on protected worksheets. However, if collaborators open the file using an older, incompatible version of the Excel desktop client, it might cause synchronization errors or fail to enforce the strict cell-level protection properly.

Document & File Issues