Data Import & Export

Fix Excel Stock Prices Not Updating on a Protected Sheet

Khadija Khan Sep 28, 2026 869 views

Question details

Users are unable to get their Excel Stock data type values to refresh automatically when the worksheet is protected.

How to Fix Excel Stock Prices Not Updating on a Protected Sheet

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to update financial data using the built-in Stock data type while the active worksheet has protection enabled.
Observed behavior: The stock prices and related background data connections fail to update or refresh, as the worksheet protection blocks the necessary write access.

Before you start

Ensure you have the required password to unprotect the worksheet, and verify that your device has an active internet connection to pull the latest stock market data.

Solution 1Recommended

Unlock the Cells Containing Stock Data

By unlocking only the specific cells that contain Stock data types, you can keep the rest of your worksheet protected while allowing external data connections to refresh.

Worksheet protection in Excel is designed to prevent unintended changes to locked cells. Since refreshing a Stock data type actively writes new values into the cells, the background process is blocked if those cells are locked. You must remove the lock status from these specific cells prior to protecting the sheet.

Unprotect the worksheet

Navigate to the 'Review' tab on the Excel ribbon and click 'Unprotect Sheet'. Enter the password if prompted.

Select the Stock data cells

Highlight all the cells and columns that contain the Stock data types and any linked fields that need to be updated.

Unlock the selected cells

Press 'Ctrl + 1' on your keyboard to open the Format Cells dialog box. Go to the 'Protection' tab, uncheck the 'Locked' box, and click 'OK'.

Reprotect the worksheet

Go back to the 'Review' tab and click 'Protect Sheet'. Ensure that the 'Select unlocked cells' permission is checked, then apply the protection.

Data Refresh Enabled: Your stock prices will now update normally when clicking 'Refresh All', while the formulas and layout in the rest of your spreadsheet remain securely protected.

Solution 2

Temporarily Unprotect to Refresh Data

If you do not want to leave any cells unlocked, you can manually remove the protection, update the data, and reapply the security.

Free Microsoft Office alternative

Try WPS Office for a Seamless Spreadsheet Experience

Since Excel's proprietary linked data types can sometimes be restrictive when working with protected sheets and external data connections, consider trying WPS Office. It provides a lightweight, highly compatible alternative for managing complex spreadsheets, offering an intuitive approach to worksheet security and data formatting without the heavy subscription fees.

1. Download and Install: Visit the official WPS Office website to download the free suite and follow the quick installation prompts.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbook directly. No format conversion is required.
3. Manage Data Securely: Use the familiar Review tab to protect or unprotect your sheets while maintaining full control over your data imports.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Free and lightweight alternative to Microsoft 365Intuitive worksheet protection and data management toolsFamiliar user interface for a zero-learning-curve transition

microsoft office alternative - wps office

Frequently Asked Questions

Can I refresh external data connections on a protected Excel sheet without unlocking cells?

Generally, no. Excel requires the cells receiving external data to be unlocked before applying sheet protection. If the cells are locked, the refresh action is blocked to prevent unauthorized overwriting of data.

Why do standard formulas work on a protected sheet, but Stock data does not?

Standard formulas only read existing data and perform calculations without structurally modifying locked cells. Stock data types, however, rely on background data connections that actively attempt to write new, downloaded information into the cells, an action which worksheet protection intentionally blocks.

Will unlocking the stock cells break my formulas?

No. Unlocking a cell only allows its contents to be edited or updated by data connections while the sheet is protected. Any formulas referencing those unlocked stock cells will continue to calculate correctly.

Excel & Data Problems