Others

How to Fix Excel Stock Prices Not Updating or Adding New Stocks

Aamir Naveed Akram Sep 29, 2026 868 views

Question details

The user needs to resolve an issue where Excel fails to update existing stock prices or add new stock data types due to a service connection failure.

How to Fix Excel Stock Prices Not Updating or Adding New Stocks

Product: Microsoft Excel
Device & OS: not provided
Scenario: Tracking stock portfolios or managing financial data using Excel's built-in Stock data types.
Observed behavior: Stock prices have not updated for several days, and the system prevents adding new stocks, indicating that the connected stock-data service is offline.

Before you start

Verify that your computer has a stable internet connection and that you are signed into an active Microsoft 365 account, as the Stock data feature requires both to function properly.

Solution 1Recommended

Report the Service Issue and Monitor Status

When the stock data provider experiences a confirmed server outage, the best course of action is to report the issue to the Office development team and wait for a fix.

Excel relies on a third-party financial data provider to populate the Stock data types. When these external servers go down, the feature will temporarily stop working across all workbooks until Microsoft restores the connection.

Send feedback in Excel

Open your Excel workbook, navigate to the 'Help' tab on the ribbon, and click on 'Send Feedback'. Choose 'Report a Problem' to notify the development team about the stock data outage.

Check Microsoft service status

Visit the official Microsoft 365 Service Health status page in your web browser to check if there are any documented outages regarding Office data connections.

Monitor community updates

Keep an eye on the official Microsoft Community forums or Microsoft Support social media channels for real-time updates on when the stock-data service will be restored.

Report the Service Issue and Monitor Status

Server-side Resolution: Because this is a server-side issue, local troubleshooting will not fix it. Once Microsoft resolves the provider outage, your workbook will automatically regain the ability to fetch and update stock prices.

Solution 2

Force a Manual Data Refresh

If the service has recently been restored but your workbook is still stuck, a manual data refresh can re-establish the connection to the stock data service.

Free Microsoft Office alternative

Use WPS Office for Reliable Financial Spreadsheets

If you are frustrated by frequent service outages in Microsoft Office, consider switching to WPS Office. It is a free, highly compatible alternative that lets you manage your financial data effortlessly without heavy subscriptions.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite to your computer.
2. Open your financial workbook: Launch WPS Spreadsheets and open your existing .xlsx portfolio file.
3. Manage your data: Continue tracking your finances, applying formulas, and managing your investments with ease.

Seamless compatibility with Microsoft Excel (.xlsx) filesLightweight design that runs smoothly on all devicesFamiliar user interface for a zero-learning-curve transitionCompletely free to use for personal and daily productivity tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say the stock data service is unavailable?

This error typically occurs when Microsoft's third-party financial data provider experiences server issues, or if your local network firewall blocks access to the data endpoints.

Do I need a specific subscription to use Stock data types?

Yes, the Stock data feature is exclusive to active Microsoft 365 subscribers. It is not available in older perpetual license versions such as Office 2019 or Office 2016.

Will my existing stock data be lost during a service outage?

No, your existing stock prices and company data will remain cached in your workbook. They simply will not update to the latest market values until the service connection is fully restored.

Office Quick Solutions