License & Subscription Issues

Fix Excel STOCKHISTORY and Stock Data Access Problems

Ayan MasoodAyan Masood Nov 13, 2026 868 views

Question details

The user needs to troubleshoot Excel STOCKHISTORY and linked stock-data features that are unavailable or not working by checking connected experiences, Microsoft 365 licensing, Office updates, and account access.

Fix Excel STOCKHISTORY and Stock Data Access Problems
Product
Microsoft Excel / Microsoft 365
Device & OS
not provided
Scenario
A user depends on Excel's STOCKHISTORY function or linked stock data types and needs to restore access when the feature does not load data.
Observed behavior
STOCKHISTORY or linked stock data does not load, returns an error, or is unavailable in Excel.
Before you start

Confirm that your Microsoft 365 subscription is active and that Excel can reach the internet. If you use a work or school account, check with your administrator that connected experiences are not disabled by policy.

Solution 1Recommended

Enable Connected Experiences in Excel Privacy Settings for Stock Data

Use this first when STOCKHISTORY or linked stock data is unavailable because Excel may be blocking online content through privacy settings.

Excel stock data is delivered through Microsoft connected experiences. If these options are turned off, STOCKHISTORY and related linked data types can fail even when the rest of Excel works normally.

1
Open Excel Options

In Excel, select File > Options.

2
Go to Privacy Settings

Select General, scroll to Privacy Settings, and enable the connected-experience options that allow Excel to access online content and analyze content.

3
Restart Excel and test

Click OK, restart Excel, and test STOCKHISTORY or the linked stock data type again.

Enable Connected Experiences in Excel Privacy Settings for Stock Data
Stock data restored: If stock data appears after the restart, the connected experience setting was blocking the feature.
Free Microsoft Office alternative

Use WPS Office as a Free Spreadsheet Alternative to Excel

WPS Office cannot repair Microsoft's STOCKHISTORY service or Microsoft 365 licensing, but it offers a free, lightweight spreadsheet alternative with familiar formulas, XLSX compatibility, and easy migration for daily spreadsheet work.

Free to download and use for everyday spreadsheet work, reducing Microsoft 365 licensing dependency.Opens and saves .xlsx, .xls, and other Microsoft Office formats with high compatibility.Familiar ribbon interface and formula support make it easy to switch from Excel.Core spreadsheet editing and analysis do not depend on Microsoft online stock-data services.
microsoft office alternative - wps office

Frequently Asked Questions

Where do I enable connected experiences for Excel stock data?

In Excel, select File > Options > General, scroll to Privacy Settings, and turn on the connected-experience options that allow access to online content. Then restart Excel and test STOCKHISTORY again.

How do I check which Microsoft 365 license is active in Excel?

Go to File > Account. Under Product Information or Subscription Product, confirm the active Microsoft 365 plan and signed-in account that includes Excel.

Why is STOCKHISTORY still unavailable after I updated Excel?

The stock data service may be temporarily down, restricted by region, or disabled by a work or school administrator. Check the Microsoft 365 service health page and sign in again with the licensed account.

Does WPS Office include the STOCKHISTORY function?

WPS Office does not include Microsoft's STOCKHISTORY service, but it supports XLSX editing and core spreadsheet functions for daily work.

Can a Microsoft 365 subscription issue block Excel stock data?

Yes. An expired or incorrect license can disable connected stock-data features. Verify File > Account and sign in with the subscribed account.