'%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)
Fix Excel Data Types (Stocks and Geography) Missing in Office 2021
Question details
The user is unable to access Stocks and Geography data types in Excel and needs to understand why they are missing or how to enable them.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to use connected data types like Stocks or Geography for financial or geographical data analysis in a spreadsheet.
- Observed behavior
- The Stocks and Geography data types do not appear in the Data tab ribbon despite standard troubleshooting steps being completed.
Verify your Microsoft Office version by opening Excel, clicking on File, selecting Account, and checking the Product Information section to confirm whether you are using Office Professional Plus 2021 or a Microsoft 365 subscription.
Upgrade to a Microsoft 365 Subscription
Stocks and Geography data types are cloud-connected features exclusive to Microsoft 365. Upgrading your license is the only direct way to unlock them on the desktop app.
Perpetual versions of Microsoft Office, such as Office Professional Plus 2021, Office 2019, and Office 2016, do not include premium cloud-connected features. To use the built-in Stocks and Geography data types, you must have an active Microsoft 365 plan.
Navigate to the official Microsoft website and subscribe to a Microsoft 365 Personal, Family, or Business plan using your Microsoft account.
Open Excel, click on 'File', select 'Account', and click the 'Change License' button under Product Information to sign in with your new Microsoft 365 credentials.
Restart the Excel application. Go to the 'Data' tab on the top ribbon, and you will now see the 'Stocks' and 'Geography' icons inside the Data Types group.
Use Excel for the Web (Free Workaround)
Access basic connected data types without purchasing a subscription by utilizing the free online version of Excel.
Try WPS Office for Your Spreadsheet Needs
If you need a powerful, cost-effective spreadsheet application without expensive recurring subscriptions, WPS Office provides an excellent, lightweight alternative that is highly compatible with your existing Microsoft Excel files.
- 1. Download and Install: Visit the official WPS Office website and download the free version for your Windows, Mac, or Linux operating system.
- 2. Open Your Excel Files: Launch WPS Spreadsheets and seamlessly open your existing .xlsx workbooks without losing any formatting or formulas.
- 3. Explore Advanced Data Tools: Navigate to the Data tab to explore built-in data processing, sorting, and analytical tools designed for high efficiency.
Frequently Asked Questions
Why did the Stocks and Geography data types suddenly disappear from my Excel?
If you recently transitioned from a Microsoft 365 subscription to a perpetual license like Office Professional Plus 2021, these premium cloud-connected features are automatically removed, as they are exclusive to the subscription model.
Can I buy Stocks and Geography data types as an add-in for Office 2021?
No, Microsoft does not offer these connected data types as a separate add-in or one-time purchase for perpetual Office versions. They strictly require an active Microsoft 365 subscription.
Are there any free ways to get live stock data in Excel without a subscription?
Yes, you can manually import stock data by going to the 'Data' tab, selecting 'From Web', and pasting the URL of a financial website (like Yahoo Finance) to pull live stock quotes into a data table.
