Excel Error Codes

How to Fix Excel Stocks Data Type Server Error

Maira Mehtab Sep 22, 2026 869 views

Question details

Users experience an error message stating that the server is temporarily having problems when attempting to enter a stock ticker using the Excel Stocks data type.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using the linked Stocks data type to fetch live or delayed financial data for a specific stock ticker like MSFT.
Observed behavior: Excel displays a server error message and fails to load or refresh the requested stock data information.

Before you start

Ensure you have a stable internet connection, as the Stocks data type relies on connecting to external financial data servers to retrieve information.

Solution 1Recommended

Restart Excel and Your Computer

Since this error is frequently caused by temporary service disruptions or local connection glitches, a quick restart can refresh your session and resolve the connection to the data service.

The Stocks data type in Excel connects to an online service to pull real-time or delayed stock information. Sometimes, temporary server outages, background updates, or local network caching issues can interrupt this link. Restarting forces Excel to establish a fresh connection to Microsoft's linked data servers.

Close Microsoft Excel

Save your current workbook and completely close the Microsoft Excel application.

Restart your computer

Reboot your computer to clear any lingering network connection states or temporary local network glitches.

Test the Stocks data type again

Open Excel, type a stock ticker (e.g., 'MSFT') in a cell, and navigate to the 'Data' tab. Click on 'Stocks' to see if the data loads successfully.

Check Microsoft 365 Service Status: If the issue persists, the problem may be a widespread temporary service issue affecting linked data types. You can verify this by checking the official Microsoft 365 service health dashboard online.

Free Microsoft Office alternative

Manage Your Financial Data Efficiently with WPS Office

If you are tired of dealing with Excel's server connectivity errors and linked data service issues, consider switching to WPS Office. WPS Spreadsheet offers a lightweight, robust, and highly compatible platform to manage your financial tracking sheets and data analysis.

1. Download and Install WPS Office: Visit the official WPS Office website and download the free software suite.
2. Open Your Financial Workbook: Launch WPS Spreadsheet and open your existing .xlsx financial tracking file.
3. Manage Data Smoothly: Continue your data entry and financial analysis using WPS's powerful offline and online tools without worrying about server disruptions.

Fully compatible with Microsoft Excel (.xlsx) file formatsReliable and lightweight spreadsheet tool without heavy online dependenciesFree to use with a familiar, easy-to-navigate user interfaceIncludes hundreds of built-in financial formulas for data analysis

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say the server is temporarily having problems when using Stocks?

This error usually occurs when Microsoft's data provider experiences an outage, or your local network has trouble reaching the financial data servers. It is generally a temporary issue that resolves itself after a short time.

Do I need a specific Microsoft 365 subscription to use the Stocks data type?

Yes, the Stocks data type is a premium feature available primarily to Microsoft 365 subscribers. Ensure your account is active and you are signed into the correct Microsoft account within Excel.

How can I manually refresh my stock data in Excel?

To refresh stock data, go to the 'Data' tab on the Excel ribbon and click 'Refresh All'. This forces Excel to reach out to the server and update the connected stock information.

Can firewall settings cause Excel server errors?

Yes. If your network firewall or antivirus software blocks Excel from accessing the internet, it won't be able to retrieve linked data. Ensure Excel is allowed through your firewall settings.

Microsoft Office Error Codes