'%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 Stocks Data Type Missing in Office 2021
Question details
The user is unable to find or use the Stocks data type in Excel 2021, even after attempting basic troubleshooting steps like application repair and Safe Mode.
- Product
- Microsoft Excel 2021
- Device & OS
- not provided
- Scenario
- Trying to access the Stocks or Geography data types in Excel to pull real-time financial or geographical data.
- Observed behavior
- The Stocks data type feature is completely missing, unavailable, or disabled in the Excel ribbon.
Ensure you have an active internet connection, as linked data types in Excel require access to online connected services to retrieve and update real-time data.
Verify Microsoft 365 Subscription and License Status
The Stocks and Geography data types are premium cloud features that require a Microsoft 365 subscription and are generally not supported in standalone Office 2021.
Microsoft restricts certain cloud-connected features, such as the Stocks and Geography data types, exclusively to Microsoft 365 subscribers. If you purchased a one-time perpetual license for Office 2021, these features will not be available by default even if your software is fully updated.
Launch Excel, click on 'File' in the top-left corner of the ribbon, and select 'Account' from the bottom-left menu pane.
Look under the 'Product Information' section to see your exact license. Check if your version says 'Microsoft Office 2021' or 'Microsoft 365 Apps'.
If your license is listed as Office 2021 and you absolutely require the Stocks data type for your workflow, you will need to upgrade to a Microsoft 365 subscription.
Enable Optional Connected Experiences
If you have a qualifying Microsoft 365 account but still can't see the feature, your privacy settings might be blocking connected services.
Manage Your Financial Data Effortlessly with WPS Office
If upgrading to a Microsoft 365 subscription isn't an option, consider WPS Office as a free, lightweight, and highly compatible alternative. It provides powerful spreadsheet capabilities, advanced financial functions, and a familiar user interface without the expensive monthly fees.
- 1. Download and Install: Download WPS Office from the official website and follow the simple on-screen instructions to install it on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and click 'Open' to seamlessly load your existing Excel financial tracking files without losing formatting.
- 3. Manage Financial Data: Use WPS Spreadsheet's comprehensive formulas, pivot tables, and charting tools to track and analyze your stock and financial data effectively.
Frequently Asked Questions
Why is the Stocks data type grayed out in my Excel ribbon?
The feature may be grayed out if you are currently offline, if 'optional connected experiences' are disabled in your Trust Center privacy settings, or if you are not signed in to an active Microsoft 365 subscription account.
Can I get Excel linked data types without a Microsoft 365 subscription?
Currently, full access to Stocks, Geography, and other linked data types in the desktop app requires a Microsoft 365 subscription. Standalone versions like Office 2019 or Office 2021 do not support these premium cloud-connected features natively.
How do I refresh data for the Stocks data type if I have it?
If your account supports the feature, you can refresh your financial data by navigating to the 'Data' tab on the ribbon and clicking the 'Refresh All' button to pull the latest stock market information.
