Office Settings & Configuration

Fix Excel Stock Quotes Feature Grayed Out or Missing

Olivia MillerOlivia Miller Nov 4, 2026 868 views

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.

How to Fix Excel Stock Quotes Feature Grayed Out
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

Launch Excel, click on 'File' in the top-left corner, and select 'Options' at the bottom of the left-hand menu.

2
Navigate to Privacy Settings

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'.

3
Enable Optional Connected Experiences

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.

Enable Connected Experiences in Excel Trust Center
Workplace IT Policies: If the checkbox for connected experiences is grayed out, your company's IT administrator may have disabled this feature globally via Group Policy.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks without losing any formatting or core data.
  3. 3. Analyze Your Data: Use built-in financial formulas and charting tools to track and analyze your stock and market data manually.
Completely free and lightweight spreadsheet softwareSeamlessly compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Hundreds of built-in financial, statistical, and logical functions for data analysisClean, familiar user interface with no confusing region locks or connected experience requirements
microsoft office alternative - wps office

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.