Excel 2021 for Mac: Why the Stocks Data Type Is Missing
Question details
Understand why the Stocks data type is missing from Excel 2021 for Mac and how to access it with an eligible subscription.

- Product
- Microsoft Excel 2021 for Mac
- Device & OS
- Mac
- Scenario
- The user wants to select the Stocks data type from the Data tab in Excel.
- Observed behavior
- The Stocks option is not visible on the Data tab.
Open Excel and choose Excel > About Microsoft Excel to check the active license. Have the account associated with your eligible Microsoft 365 subscription ready; if your organization manages Office, check with your administrator before changing the license.
Activate Excel with an Eligible Microsoft 365 License
Use this approach if Excel shows a perpetual Office LTSC 2021 license and you have an eligible Microsoft 365 subscription.
Office LTSC Standard for Mac 2021 is a one-time-purchase edition and does not include the Stocks data type. Installing Microsoft 365 apps alone does not change the active license.
In Excel, select Excel > About Microsoft Excel and review the license information. If it shows Office LTSC Standard for Mac 2021, the perpetual license is active.
Sign in to your Microsoft account or contact your organization's administrator to confirm that your account has an eligible Microsoft 365 subscription.
Follow Microsoft's support instructions for removing Office license files on a Mac and run the Microsoft license removal tool. This removes Office license files from the Mac, so check with your administrator first if the device is managed.
Open Excel and sign in with the eligible Microsoft 365 account. Then choose Excel > About Microsoft Excel and confirm that the license information says Microsoft 365 Subscribers.
Open a workbook and select the Data tab to look for Stocks in the data types options.
Work with Stock Lists in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and Excel file compatibility for an easier move between office suites. Use WPS Spreadsheets to organize stock symbols and manually entered market data; it does not fix an Excel license or provide Excel's Stocks data type.

Frequently Asked Questions
Why is Stocks missing from the Data tab in Excel for Mac?
The active license may be Office LTSC Standard for Mac 2021, a perpetual edition that does not include the Stocks data type. Check Excel > About Microsoft Excel to see which license is active.
Will installing Microsoft 365 apps automatically enable Stocks?
Not necessarily. Excel must also be activated with an eligible Microsoft 365 account. Check Excel > About Microsoft Excel and confirm that the license information says Microsoft 365 Subscribers.
How do I switch from an LTSC license to my Microsoft 365 subscription?
Follow Microsoft's instructions to run its license removal tool for Mac, then reopen Excel and sign in with your eligible Microsoft 365 account. If your organization manages the device, contact your administrator before removing licenses.
Can WPS Office enable the Stocks data type in Excel?
No. WPS Office cannot change an Excel license or enable an Excel feature. You can use WPS Spreadsheets as an alternative to organize stock lists and manually entered data in Excel-compatible files.




