Fix the Missing Stock Data Type Icon in Excel
Question details
The user needs Excel to display the Stocks data type icon and provide linked financial information for stock symbols.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Convert stock symbols to the Stocks linked data type and access financial fields.
- Observed behavior
- Excel converts symbols to company names, but the Stocks icon and linked financial information do not appear.
Make sure you have an internet connection and a list of recognizable stock symbols. If you use a managed or secure environment, check whether your organization permits Office connected experiences and access to online financial data.
Check your Excel edition and connected experiences
Use these checks when the Stocks command is available but linked data and its icon do not appear.
In Excel, open File > Account and check Product Information for your Office edition and signed-in account. Availability can vary by edition, version, account, and region.
Under File > Account, select Update Options > Update Now if that option is available. Reopen Excel after the update.
Go to File > Account > Account Privacy > Manage Settings and check whether optional connected experiences are enabled. If settings are managed by your organization, ask your administrator about access.
Enter a stock symbol in a cell, select it, and choose Data > Stocks. If Excel offers a data selector, choose the matching company, then check for the data type icon and the Insert Data button.

Confirm support or consider Microsoft 365
Use this approach if updates and connected-experience settings do not restore linked stock data.
Work with Stock Tables in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move existing files. You can enter or import stock data for analysis, although WPS does not fix Excel's linked Stocks data type.

Frequently Asked Questions
Why does Excel show a company name but no Stocks icon?
The name may appear without the full linked data type being available. Check your edition under File > Account, then review connected experiences and service availability.
Does the Stocks data type work in Office 2019?
The full linked Stocks experience may not be available in some perpetual Office 2019 installations or restricted environments. Check Microsoft's current availability information for your edition, account, and region.
Where can I enable connected experiences in Excel?
Open File > Account > Account Privacy > Manage Settings and review the connected-experience options. Your organization may control these settings.
Can WPS Office restore Excel's missing Stocks icon?
No. The icon and linked financial data depend on Microsoft's Excel services. WPS Spreadsheet can open Excel files and help you work with stock data entered or imported separately.




