'%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)
Why the Stocks Data Type is Missing in Excel Office Professional Plus 2021
Question details
The user is unable to locate the Stocks button and Data Types group within Excel.
- Product
- Microsoft Excel (Office Professional Plus 2021)
- Device & OS
- not provided
- Scenario
- Attempting to use the Stocks data type to fetch automated financial and market data for a spreadsheet.
- Observed behavior
- The Stocks button and the entire Data Types group are completely missing from the Data ribbon, even when the user is signed in with a Microsoft account.
Verify your exact Microsoft Office version by opening Excel, clicking on 'File', and selecting 'Account' to view your license and subscription details.
Access the Stocks Data Type via Excel for the Web
Since the Stocks feature is not included in the perpetual Office Professional Plus 2021 license, you can access it for free by using the cloud-based web version of Excel.
Microsoft restricts certain cloud-connected data types to subscription models and web apps. Using Excel for the Web is the quickest workaround without spending additional money.
Open your preferred web browser and navigate to office.com.
Log in using your free personal Microsoft account or your work/school credentials.
Click on the Excel icon located on the left-hand sidebar. Create a new blank workbook or upload your existing spreadsheet to OneDrive to open it.
Type company names or ticker symbols into cells and highlight them. Go to the 'Data' tab on the ribbon, locate the Data Types group, and click 'Stocks'.
Upgrade to a Microsoft 365 Subscription
Switching to a subscription-based Microsoft 365 plan unlocks premium cloud-connected features on the desktop app, including the missing Data Types.
Looking for a Free, Fully-Featured Office Suite?
Frustrated by version restrictions and missing features in perpetual Office licenses? WPS Office offers a free, lightweight, and powerful alternative that is highly compatible with Microsoft Excel formats. Enjoy a robust spreadsheet tool without the burden of expensive, ongoing subscriptions.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install the Software: Run the downloaded setup file and follow the simple on-screen instructions to complete the installation.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files to instantly resume your work.
Frequently Asked Questions
Is the Stocks data type available in Office 2019?
No, just like Office 2021, Office 2019 is a perpetual, one-time purchase license. The Stocks data type is exclusively available to Microsoft 365 subscribers and users of the free Excel for the Web application.
Why is my Data Types group completely greyed out in Excel?
The Data Types group may appear greyed out if you are working completely offline, if your file is saved in an older format like .xls instead of .xlsx, or if you are not currently signed into an account with an active Microsoft 365 subscription.
Can I manually add the Stocks button to my Excel 2021 ribbon?
No, customizing the ribbon via settings to force the Stocks button to appear will not work. The underlying cloud service required to pull financial data is disabled at the license level for Office Professional Plus 2021.
How do I update financial data once I have added the Stocks data type?
Once you have successfully applied the Stocks data type to a cell (e.g., in Excel for the Web), you can update the financial information by right-clicking the cell and selecting 'Refresh', or by clicking 'Refresh All' directly on the Data tab.
