Function Problems

Fix the Missing Stock Data Type Icon in Excel

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

The user needs Excel to display the Stocks data type icon and provide linked financial information for stock symbols.

Fix the Missing Stock Data Type Icon in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Check your Office edition

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.

2
Install available updates

Under File > Account, select Update Options > Update Now if that option is available. Reopen Excel after the update.

3
Review privacy settings

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.

4
Try the Stocks command again

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.

Check your Excel edition and connected experiences
A company name alone is not confirmation: A displayed company name does not necessarily mean the cell has the full linked Stocks data type. The icon and available fields are better indicators.
Free Microsoft Office alternative

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.

Organize and analyze manually entered or imported stock dataOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight Office suite
microsoft office alternative - wps office

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.