License & Subscription Issues

Excel 2021 for Mac: Why the Stocks Data Type Is Missing

Amos GikundaAmos Gikunda Nov 14, 2026 869 views

Question details

Understand why the Stocks data type is missing from Excel 2021 for Mac and how to access it with an eligible subscription.

Why the Stocks Data Type Is Missing in Excel 2021 for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Check 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.

2
Confirm your subscription

Sign in to your Microsoft account or contact your organization's administrator to confirm that your account has an eligible Microsoft 365 subscription.

3
Remove the existing license

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.

4
Reactivate and verify

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.

5
Check the Data tab

Open a workbook and select the Data tab to look for Stocks in the data types options.

No eligible subscription?: The perpetual Office LTSC Standard for Mac 2021 license does not provide the Stocks data type. An eligible Microsoft 365 subscription is needed to use it in Excel.
Free Microsoft Office alternative

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.

Organize stock symbols, prices, and notes in a spreadsheetOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

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.