Data Import & Export

How to Fix Excel Stock Prices Not Updating When Refreshed

Huma Ashraf Ch Sep 30, 2026 868 views

Question details

The user is experiencing an issue where linked stock prices in an Excel workbook fail to update or refresh upon request.

How to Fix Excel Stock Prices Not Updating When Refreshed

Product: Microsoft Excel
Device & OS: not provided
Scenario: Refreshing linked financial and stock data in an existing workbook to get the latest market values.
Observed behavior: The stock data does not refresh, despite the feature working previously, which may indicate an application bug or an external service disruption.

Before you start

Ensure your device has a stable internet connection and that you are actively signed into the Microsoft 365 account linked to your subscription, as the Stocks data type requires premium access to sync.

Solution 1Recommended

Refresh Data Using Excel for the Web

Using the web version of Excel can bypass local application bugs and successfully force the stock data to sync.

Because this issue is frequently tied to a bug within the Excel desktop application, moving your environment to the cloud can act as an immediate workaround. Excel for the Web pulls data directly from Microsoft's online services, minimizing local software interference.

Save to OneDrive

Upload or save your affected Excel workbook to your Microsoft OneDrive account.

Open Excel for the Web

Launch a web browser, such as Microsoft Edge, navigate to Excel Online, and open your saved workbook.

Refresh All Data

Go to the 'Data' tab on the top ribbon and click the 'Refresh All' button to prompt the stock prices to update.

Check Data Connections: Ensure that the cells are still correctly formatted as the 'Stocks' data type. You should see a small building icon next to the company name.

Solution 2

Submit a Bug Report to Microsoft

If the stock data still refuses to update online, it is likely a widespread service outage or recognized bug that needs to be reported to the development team.

Free Microsoft Office alternative

Switch to WPS Office for a Reliable Spreadsheet Experience

If you are tired of dealing with subscription bugs and sync failures in Microsoft Excel, WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy seamless document migration, a familiar user interface, and powerful spreadsheet tools without the premium price tag.

1. Download and Install: Download the free WPS Office suite from the official website and install it on your device.
2. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx financial tracking documents directly.
3. Manage Data Freely: Utilize a wide range of familiar formulas, pivot tables, and charting tools to seamlessly continue your work.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Lightweight and fast architecture, preventing common local application crashes and lag.Familiar user interface makes migrating your financial workbooks completely seamless.Free alternative featuring robust built-in data analysis and visualization tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel stock data suddenly stop working?

This typically occurs due to temporary Microsoft service outages, an application bug introduced in a recent update, or being signed out of the Microsoft 365 account required to access the feature.

Does the Stocks data type require a specific subscription?

Yes, the linked Stocks data type in Excel requires an active Microsoft 365 subscription. If your subscription has expired or cannot be verified, the data will no longer refresh.

Can I manually update stock prices if the refresh button fails?

While you cannot manually force the linked data type to sync if the Microsoft service is down, you can temporarily import current data by setting up a web query or downloading a CSV file directly from a financial website.

Excel & Data Problems