Fix Excel Stock Data Type Not Recognizing a New Ticker
Question details
The user is experiencing an issue where a newly listed stock ticker is recognized in Excel Online but fails to be recognized by the desktop version of Excel's Stock Data Type.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to track a recently listed stock ticker using the Stocks data type feature in Excel.
- Observed behavior
- The ticker is successfully identified in Excel Online but returns an error or remains unrecognized in the Excel desktop application.
Ensure you have an active Microsoft 365 subscription and a stable internet connection, as the Stocks data type requires both to retrieve financial data from external providers.
Manually Update Microsoft 365 and Refresh Data
Ensure your desktop application has the latest updates and force a refresh of the linked data types.
Microsoft frequently updates the background services that power linked data types. Ensuring your desktop application is fully up-to-date is the most reliable way to sync the latest available tickers.
Open Excel, go to 'File', select 'Account', click on 'Update Options', and choose 'Update Now'.
Once updated, open your workbook, navigate to the 'Data' tab, and click 'Refresh All' in the Queries & Connections group to force the data type to sync with the latest market data.

Specify the Stock Exchange
Force Excel to search the correct database by explicitly specifying the exchange prefix along with the ticker symbol.
Use Excel Online as a Temporary Workaround
If the desktop version hasn't updated yet, use Excel Online which often receives data provider updates faster.
Try WPS Office for Your Spreadsheet Needs
If you frequently encounter data sync delays or platform discrepancies in Microsoft Excel, consider WPS Office. It provides a lightweight, fast, and highly compatible spreadsheet experience without heavy subscription costs.
- 1. Download the Installer: Visit the official WPS Office website and click 'Free Download' to get the installer package.
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up WPS Spreadsheet on your device.
- 3. Open Your Workbooks: Open your existing Excel workbooks directly in WPS Office to continue your financial tracking effortlessly.

Frequently Asked Questions
How long does it take for a new IPO to appear in Excel's Stock Data Type?
It can vary significantly. While some major tickers appear within a few days, others may take several weeks or even months depending on when Microsoft's external market-data provider updates its database across all platforms.
Why does Excel Online recognize a stock that desktop Excel does not?
Excel Online operates on a continuous cloud release cycle and connects directly to data services instantly, whereas the desktop application relies on local cache and scheduled background service updates, leading to temporary discrepancies.
Can I manually add a stock ticker if Excel doesn't recognize it?
No, you cannot manually inject a new linked data entity into the built-in Stocks data type. You must wait for the data provider to update, or alternatively, use the 'From Web' data query tool to scrape the data manually from a financial website.




