Permission & Access Issues

How to Fix Excel Locked Cells Changing After Downloading from SharePoint

Amos Gikunda Oct 16, 2026 868 views

Question details

Users need to troubleshoot an issue where the locked or unlocked status of cells in an Excel workbook alters unexpectedly after downloading the file from SharePoint or OneDrive.

How to Fix Excel Locked Cells Changing After Downloading from SharePoint

Product: Microsoft Excel, SharePoint, OneDrive
Device & OS: not provided
Scenario: Downloading, opening, or syncing a shared Excel workbook via SharePoint or OneDrive.
Observed behavior: Cell protection settings (locked/unlocked attributes) appear to be lost, modified, or corrupted after the file is accessed locally.

Before you start

Ensure you have the correct permissions to view and edit the SharePoint file, and check that your local Microsoft Office application is completely up to date to rule out basic sync glitches.

Solution 1Recommended

Test the Workbook Across Different Platforms

Identify if the issue is isolated to your local Excel desktop application by testing the file in Excel for the Web.

Often, compatibility issues between older desktop versions of Excel and the Office 365 SharePoint environment can cause cell protection metadata to read incorrectly. Testing online helps isolate the root cause.

Open in Excel for the Web

Navigate to your SharePoint or OneDrive document library in your web browser. Click on the Excel file to open it directly in Excel for the Web instead of downloading it.

Verify Cell Protection

Check if the locked and unlocked cells behave correctly in the web version. If they do, the issue is likely tied to your local desktop application.

Create a Local Test File

Open your local Excel desktop app, create a new blank workbook, apply locked/unlocked settings to specific cells, and upload it to SharePoint to see if the issue replicates.

Test the Workbook Across Different Platforms

Version Compatibility: If the issue only occurs locally and for multiple users, it may be caused by compatibility conflicts with older Excel versions during an Office 365 migration.

Solution 2

Restore an Earlier Version of the File

Use SharePoint's version history to revert the file to a state before the cell protection settings were corrupted.

Solution 3

Submit a Support Request in Microsoft 365 Admin Center

If the problem persists across multiple workbooks and affects multiple users, request a backend investigation from Microsoft Support.

Free Microsoft Office alternative

A Reliable Alternative for Protecting Spreadsheets

If SharePoint synchronization continues to break your Excel cell protection, WPS Office offers a highly stable and lightweight alternative. It ensures your locked cells and sensitive data remain securely protected without unexpected format changes across different devices.

1. Download WPS Office: Visit the official WPS Office website and install the free software on your device.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files directly. Your formats and formulas will be preserved.
3. Apply Reliable Protection: Navigate to the 'Review' tab to lock cells and protect your worksheets securely, bypassing Microsoft Office sync bugs.

Seamless compatibility with Microsoft Excel (.xlsx) formatsRobust cell locking and sheet protection featuresFamiliar user interface for a zero-learning-curve transitionFree, lightweight, and fast to install and open large workbooks

microsoft office alternative - wps office

Frequently Asked Questions

Why do my locked cells change when downloaded from SharePoint?

This can happen due to compatibility issues between older desktop versions of Excel and the newer SharePoint/Office 365 environment, or due to synchronization glitches during the download process that fail to read the protection metadata correctly.

How can I check if the issue is with the file or my desktop app?

Open the file directly in Excel for the Web. If the locked cells function correctly online but fail when downloaded and opened on your desktop, the issue likely lies within your local Excel application installation or its version compatibility.

Will restoring an older file version fix the locked cells?

Yes, if the metadata corruption occurred during a recent upload or sync, accessing the SharePoint 'Version history' and restoring a previously working iteration can successfully recover your original cell protection settings.

Can I lock cells in WPS Office just like in Microsoft Excel?

Absolutely. WPS Office provides full worksheet protection features, allowing you to format specific cells as locked or hidden and protect the entire sheet with a password. It is fully compatible with Excel's protection standards.

Document & File Issues