Fix Excel Stock Quotes Feature Grayed Out or Missing
Question details
The user is unable to access the built-in Stock Quotes data type in Excel because the feature is grayed out or entirely unavailable.

- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Attempting to use the Stock data type to retrieve automated financial and market information within a spreadsheet.
- Observed behavior
- The Stock Quotes data type button in the Data tab is grayed out and unresponsive, despite the user having an active Microsoft 365 subscription.
Ensure your computer has a stable internet connection, as the Stock Quotes data type requires internet access to fetch live financial data from online providers.
Enable Connected Experiences in Excel Trust Center
Microsoft 365 requires optional connected experiences to be turned on to access cloud-backed data types like Stocks and Geography.
If your organization's IT policy or your local privacy settings have disabled Connected Experiences, the Stocks feature will immediately become grayed out. Re-enabling this setting restores the software's ability to communicate with Microsoft's data services.
Launch Excel, click on 'File' in the top-left corner, and select 'Options' at the bottom of the left-hand menu.
In the Excel Options window, click on 'Trust Center' in the left pane, then click the 'Trust Center Settings' button. Next, select 'Privacy Options' and click on 'Privacy Settings'.
Scroll down in the Privacy Settings dialog and check the box that says 'Turn on optional connected experiences'. Click 'OK' to save the changes, and restart Excel to see if the Stocks data type is active.

Verify Microsoft 365 Subscription and Update Excel
The Stocks data type is exclusive to Microsoft 365 subscribers. It will not work on perpetual licenses like Office 2016 or 2019, or if the application needs an update.
Test with a New Workbook and the STOCKHISTORY Function
Sometimes specific workbooks become corrupted or hold legacy formatting that blocks new data types. Testing in a fresh file helps isolate the issue.
Try WPS Office for a Highly Compatible Spreadsheet Experience
If Microsoft Excel's proprietary data types are unavailable due to server issues, region locks, or rigid organizational policies, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool that seamlessly handles your existing data analysis and .xlsx files without expensive subscriptions or complex privacy setting troubleshooting.
- 1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks without losing any formatting or core data.
- 3. Analyze Your Data: Use built-in financial formulas and charting tools to track and analyze your stock and market data manually.

Frequently Asked Questions
Why is the Stocks data type missing from my Excel ribbon entirely?
If the button is completely missing rather than just grayed out, you are likely using a non-subscription version of Office (such as Office 2016, 2019, or 2021). The linked data types feature is exclusively available to Microsoft 365 subscribers.
Can I use the Excel Stock Quotes feature offline?
No. Because the Stocks data type pulls real-time or delayed market quotes directly from online financial data providers, an active internet connection is strictly required to refresh or add new stock data.
Do region and language settings affect the Stock Quotes feature?
Yes. Microsoft's Linked Data Types are currently optimized for specific regions and languages, primarily English. If your operating system or Office language is set to an unsupported region, the feature may become disabled or grayed out. Ensure your language is set to English (United States) for maximum compatibility.




