'%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 Not Working in Office 2019
Question details
The user is unable to use or refresh Stock data types in Microsoft Excel and needs to restore the feature's functionality.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to access or refresh cloud-connected linked data types, specifically Stocks, within an Excel workbook.
- Observed behavior
- Excel Stock data types have stopped working or disappeared entirely, likely due to using a standalone Office 2019 license instead of an active Microsoft 365 subscription.
Ensure your computer has an active internet connection, as Excel linked data types require cloud access to retrieve real-time stock information.
Verify Your Office License and Subscription Status
Check if your current Office license supports linked data types, as standalone versions like Office Home and Student 2019 do not include this premium feature.
Excel linked data types, including Stocks and Geography, are premium cloud-connected features. They require a qualifying Microsoft 365 subscription and are generally unavailable in one-time purchase versions of Office.
Launch Microsoft Excel on your computer. Click on the 'File' tab in the top-left corner of the screen, then select 'Account' from the bottom of the left-hand menu.
Look under the 'Product Information' section on the right side. If the installed product reads 'Office Home and Student 2019' or similar standalone versions, the Stock data type is not supported on your current license.
Review the 'User Information' section to ensure you are signed in with the correct Microsoft account that has an active Microsoft 365 subscription.
Re-authenticate and Update Office Software
If you have an active Microsoft 365 subscription but the feature is still missing, signing out and forcing an update can restore missing cloud features.
Looking for a Powerful, Free Alternative to Office 2019?
If you are frustrated by premium features being locked behind costly recurring subscriptions, consider switching to WPS Office. It provides a robust, lightweight, and completely free alternative for your daily spreadsheet and document needs.
Frequently Asked Questions
Why did my Excel Stock data types suddenly disappear?
This typically occurs if a Microsoft 365 subscription or trial expires, causing Excel to default to a perpetual license like Office 2019 which does not support cloud-connected linked data types.
Can I get Stock data types in Office Home and Student 2019?
No. Microsoft restricts linked data types (like Stocks and Geography) to users with a qualifying Microsoft 365 subscription. Standalone versions like Office 2019 do not include these features.
How do I know if Microsoft's Stock data service is temporarily down?
If you have an active Microsoft 365 subscription but data won't refresh, there may be a temporary Microsoft service outage. You can check the Microsoft 365 Service Health status page or the Microsoft Community forums to see if others are reporting the same issue.
