Fix Excel Stock Data Type Names Changing to Chinese
Question details
The user wants Excel Stock Data Type company names to appear in English after a data refresh.

- 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.
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.
Refresh the stock data and verify the selected companies
Use this approach to check whether the names are associated with the correct stock entities.
Open the affected workbook in Excel, then select Data > Refresh All to update its linked data.
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.
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.

Check language and region, then report persistent names
Use this approach when the stock entities are correct but company names still appear in Chinese.
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.

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.




