Fix Excel STOCKHISTORY and Stock Data Access Problems
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.

- 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.
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.
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.
In Excel, select File > Options.
Select General, scroll to Privacy Settings, and enable the connected-experience options that allow Excel to access online content and analyze content.
Click OK, restart Excel, and test STOCKHISTORY or the linked stock data type again.

Verify the Microsoft 365 License and Account Status in Excel
Use this check when STOCKHISTORY remains unavailable after connected experiences are enabled.
Install Office Updates and Check Microsoft Service Status
Use this step when the license is active but Excel still cannot load STOCKHISTORY or linked stock data.
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.

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.




