'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Stock Data Types Showing #UNKNOWN Error
Question details
The user is experiencing an issue where Stock data types and associated formulas display as #UNKNOWN in the desktop version of Excel, despite working correctly in Excel for the Web.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using linked data types (Stocks) and related formulas in the desktop version of Excel.
- Observed behavior
- Stock names and linked data disappear and display an #UNKNOWN error in the desktop application, even though they function properly in the web version.
Ensure that your computer has an active and stable internet connection, as linked data types like Stocks require internet access to retrieve real-time data from Microsoft servers.
Verify Microsoft 365 Subscription and Update Excel
Stock data types are a premium feature that requires a qualifying Microsoft 365 subscription and the latest version of the Excel desktop app.
Linked data types are exclusive to Microsoft 365. If you purchased a standalone version of Office (like Office 2019 or 2021) or are not logged into your subscription account, the feature will not load and will display an #UNKNOWN error.
Open the Excel desktop application, click on 'File' in the top-left corner, and select 'Account' from the bottom of the menu.
Look under the 'Product Information' section to confirm that your product is activated with a Microsoft 365 subscription. Ensure you are signed in with the correct email address associated with the license.
Click on the 'Update Options' button next to the Office Updates section and select 'Update Now'. Wait for any available updates to download and install, then restart Excel.
Refresh Data Connections and Review Language Settings
Sometimes data connection glitches or localized language conflicts can cause linked data types to lose their sync and display as #UNKNOWN.
Try WPS Office for a Seamless Spreadsheet Experience
If you are frustrated by subscription-locked features and recurring errors in desktop Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative to Microsoft Office, allowing you to manage your spreadsheets without expensive subscription barriers.
- 1. Download and install: Visit the official WPS website to download and install WPS Office on your device.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx files directly without any formatting loss.
- 3. Analyze your data: Use standard financial formulas and tools to continue your work efficiently without subscription pop-ups.
Frequently Asked Questions
Why do my Excel stock data types work on the web but not on the desktop?
Excel for the Web handles data types directly on Microsoft's servers, which might allow the feature to function temporarily. Desktop Excel natively checks your local license; it strictly requires an active, signed-in Microsoft 365 subscription and the latest software updates to process linked data types.
Are stock data types available in Excel 2019 or Excel 2021?
No, linked data types like Stocks and Geography are premium cloud features exclusive to Microsoft 365 subscribers. Standalone versions like Excel 2019 and Excel 2021 do not support this feature, which is why it displays as #UNKNOWN when opened in those versions.
How can I fix the #UNKNOWN error if I already have a Microsoft 365 subscription?
First, ensure you are signed in to the correct Microsoft account by going to File > Account. If the account is correct, force an update by clicking Update Options > Update Now. Once updated, go to the Data tab and click 'Refresh All' to re-sync the data types.
