Why Excel 2019 Does Not Show Stock and Geography Data Types
Question details
Users are unable to locate or use the Stock and Geography linked data types in Microsoft Excel.
- Product
- Microsoft Excel 2019
- Device & OS
- Windows
- Scenario
- Attempting to use connected data types like Stock and Geography after reinstalling Windows and Office Professional Plus 2019.
- Observed behavior
- The Stock and Geography data types are completely unavailable or missing from the Data tab in the Excel ribbon.
Check your exact Microsoft Office version in the Account settings to verify if you are using a perpetual license (like Office 2019) or a Microsoft 365 subscription, as feature availability differs significantly between the two.
Switch to a Microsoft 365 Subscription Account
The Stock and Geography data types are exclusive cloud-connected features that are only available in Microsoft 365 subscription editions, not in the perpetual Office Professional Plus 2019 release.
Microsoft Office 2019 is a one-time purchase (perpetual license) that does not receive ongoing feature updates. Because Stock and Geography data types rely on real-time cloud services, Microsoft restricted these features to Microsoft 365 subscribers.
Launch Microsoft Excel and click on 'File' in the top-left corner, then select 'Account' from the bottom-left menu.
Under 'Product Information', verify your current license. If it says 'Microsoft Office Professional Plus 2019', you will not have access to the data types.
If you own a Microsoft 365 subscription, click 'Sign Out' on your current account, then click 'Sign In' and enter the credentials associated with your active Microsoft 365 subscription.
Click 'Update Options' and select 'Update Now' to ensure your software downloads the latest Microsoft 365 features, which will populate the Stock and Geography data types in the Data tab.
Enable Connected Experiences (For Microsoft 365 Users)
If you have upgraded to Microsoft 365 but the data types are still missing, your privacy settings may be blocking the necessary cloud connections.
Try WPS Office for Your Spreadsheet and Data Needs
Tired of confusing subscription models, hidden features, and version limitations? WPS Office offers a powerful, lightweight, and completely free alternative to Microsoft Office. It provides comprehensive spreadsheet capabilities with high compatibility for all your .xlsx files, without forcing you into expensive recurring subscriptions.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office suite and follow the quick installation prompts.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly; no conversion is required.
- 3. Analyze Your Data: Utilize advanced formulas, pivot tables, and charting tools to analyze your data efficiently without subscription paywalls.
Frequently Asked Questions
Can I manually install Stock and Geography data types into Excel 2019?
No. The Stock and Geography linked data types are native connected features tied securely to Microsoft 365 cloud services. They cannot be downloaded as an add-in or manually installed into perpetual licenses like Office 2019.
Are there alternative ways to get stock data in Excel 2019?
Yes. While you lack the automatic linked data types, you can manually import stock data from external websites by going to the Data tab, selecting 'From Web', and entering a URL containing financial data to pull it into your spreadsheet via Power Query.
Does Excel 2021 include the Stock and Geography data types?
Yes. Unlike Excel 2019, Microsoft decided to include the Stock and Geography linked data types in the one-time purchase release of Office 2021, provided you have an active internet connection to retrieve the data.
