Function Problems

Fix Excel Stock Data Types Not Working After a Few Days

Maira Mehtab Sep 28, 2026 869 views

Question details

Excel stock data types and other linked data types become unavailable or fail to refresh after functioning properly for a few days.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to use, update, or refresh linked stock data types within an Excel spreadsheet.
Observed behavior: The stock data types stop working, become completely unavailable, or the Refresh option appears disabled, indicating a potential service outage or licensing issue.

Before you start

Before troubleshooting, ensure you have a stable internet connection and verify that you are actively signed into Excel with an active Microsoft 365 subscription.

Solution 1Recommended

Verify Account Subscription and Update Office

Ensure your Microsoft 365 subscription is active and your Office app is up to date, as licensing and version mismatches often disable linked data types.

Excel's linked data types are premium features that require continuous authentication. If your sign-in token expires or your Office version falls behind, the feature may abruptly stop working.

Check Account Sign-In

Open Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand menu.

Verify Subscription

Under 'Product Information', verify that your Microsoft 365 Subscription is active and that the account listed under 'User Information' matches your subscription email.

Update Office

Click the 'Update Options' button next to 'Office Updates' and select 'Update Now' to download and install the latest patches.

Test in a New Workbook

Create a completely new blank workbook, enter a company ticker, and apply the Stock data type to test if the issue is specific to your original file.

Restart Required: After updating Office or signing back into your account, fully close and restart Excel for the licensing changes to take effect.

Solution 2

Check Microsoft Service Status and Submit Feedback

Because disabled refresh options often indicate a broader service outage with Microsoft's data providers, checking the service health and reporting the issue is a necessary step.

Free Microsoft Office alternative

Try WPS Office for a Reliable Spreadsheet Experience

If Microsoft Excel's data types are causing you frustration with frequent outages and subscription issues, consider switching to WPS Office. It provides a highly compatible spreadsheet tool that meets your daily data analysis and financial tracking needs without expensive recurring subscriptions.

1. Download and Install: Download WPS Office for free from the official website and run the installation package.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing .xlsx financial tracking files.
3. Analyze Your Data: Use the extensive library of built-in financial formulas and dynamic charts to manage your portfolios efficiently.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Free, lightweight, and fast alternative to Microsoft 365.Familiar user interface for seamless migration and zero learning curve.Rich built-in formulas, charts, and financial data processing capabilities.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel stock data types suddenly gray out?

This usually happens if Excel loses connection to the financial data provider, your Microsoft 365 subscription expires, or you are quietly signed out of your account. It can also be caused by temporary Microsoft server outages.

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

Yes, linked data types like Stocks and Geography are premium cloud features that require an active Microsoft 365 Personal, Family, or Enterprise subscription. They are not available in Office 2019 or Office 2021 standalone lifetime versions.

Can I manually refresh the stock data in Excel?

Yes, if the feature is functioning properly, you can navigate to the 'Data' tab and click 'Refresh All' to update the stock prices manually. You can also right-click a cell and select 'Data Type' > 'Refresh'.

What should I do if the Refresh button is completely disabled?

A disabled Refresh button typically indicates a licensing issue or a widespread service outage. Ensure your Office software is updated, verify your active subscription status in 'File' > 'Account', and check the Microsoft service health dashboard online.

Excel & Data Problems