Data Import & Export

Fix Excel Stock Data Type Names Changing to Chinese

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

The user wants Excel Stock Data Type company names to appear in English after a data refresh.

Fix Excel Stock Data Type Names Changing to Chinese
Product
Microsoft Excel Stock Data Type
Device & OS
not provided
Scenario
A workbook contains linked stock data that originally displayed company names in English.
Observed behavior
Some company names appear in Chinese after the linked stock data is refreshed.
Before you start

Identify a few affected company names and their ticker symbols. Check which Excel version and region you are using so you can compare the results or include them in a support report.

Solution 1Recommended

Refresh the stock data and verify the selected companies

Use this approach to check whether the names are associated with the correct stock entities.

1
Refresh the workbook

Open the affected workbook in Excel, then select Data > Refresh All to update its linked data.

2
Inspect an affected stock

Select a cell showing a Chinese company name and open its data type card. Check the ticker symbol and exchange against the company you intended to select.

3
Choose the correct entity

If the company or exchange is incorrect, right-click the cell and use Data Type > Change, if available, to select the intended stock from the Data Selector.

Refresh the stock data and verify the selected companies
Names may come from the data provider: If the correct company still appears in Chinese, its displayed name may reflect provider data or regional mapping. Refreshing or changing the selection may not restore the English name.
Free Microsoft Office alternative

Work with stock spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and move between office workflows easily, while continuing to use Excel for its linked Stock Data Type when needed.

Open and edit spreadsheets containing company names and ticker symbolsCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel stock names change to Chinese after a refresh?

The refreshed names may reflect data supplied by the stock data provider or regional mapping. Check the selected company and exchange, along with your Office language and device region; these checks may not change the provider's name.

How do I refresh stock data in Excel?

Open the workbook and select Data > Refresh All. Then check the affected cells to see whether the displayed names have changed.

How can I check whether Excel selected the right company?

Select the stock cell and open its data type card to inspect its ticker and exchange. If it is the wrong entity, right-click the cell and choose Data Type > Change, if available, to select another match.

What should I send Microsoft if the names remain in Chinese?

Use File > Feedback in Excel or contact Microsoft Support. Include the affected companies and ticker symbols, your Excel version and region, and the results of refreshing and checking the selected entities.