'%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)
Can Excel 2021 Convert Text to Stocks Data Type? Fixes & Workarounds
Question details
Users are trying to convert text into financial information using the Stocks linked data type but cannot find the feature in Excel 2021.
- Product
- Excel 2021
- Device & OS
- Windows 11
- Scenario
- Attempting to track financial data by converting standard text into the Stocks linked data type.
- Observed behavior
- The Stocks data type option is missing or unavailable in the Data tab for users running the perpetual Excel 2021 desktop application.
Verify your Microsoft Office license type by going to File > Account in Excel, as premium linked data types require an active Microsoft 365 subscription rather than a perpetual license like Office 2021.
Use Excel for the Web as a Free Workaround
Since the Stocks data type is missing in the Excel 2021 desktop app, you can use the online version of Excel to access basic linked data type features.
The Excel Stocks data type relies on connected third-party financial data, making it an exclusive feature for Microsoft 365 subscribers. It is intentionally excluded from perpetual licenses such as Office 2021. However, Microsoft provides limited access to this feature through their free web-based application.
Open your web browser, navigate to office.com, and sign in with your free Microsoft account.
Upload your spreadsheet to OneDrive and open it using Excel for the web.
Select the cells containing the company names or ticker symbols, navigate to the Data tab on the ribbon, and click on 'Stocks' in the Data Types group.
Upgrade to a Microsoft 365 Subscription
If you require the full capabilities of linked data types within the desktop application, upgrading your license is necessary.
Try WPS Office for Your Spreadsheet Needs
If you are frustrated by features being locked behind expensive subscription paywalls in Microsoft Office, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative that handles all your standard spreadsheet, document, and presentation needs without forcing you into a subscription model.
- 1. Download the installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded installer and follow the quick setup instructions on your Windows 11 PC.
- 3. Open your Excel files seamlessly: Launch WPS Spreadsheets and open your existing .xlsx files directly without any formatting loss.
Frequently Asked Questions
Why does Excel 2021 lack the Stocks data type?
The Stocks data type requires a continuous connection to third-party financial data providers. Microsoft restricts these premium cloud-connected features to Microsoft 365 subscription plans, meaning standalone perpetual licenses like Excel 2021 do not include them.
Are other linked data types missing in Excel 2021?
Yes. Alongside Stocks, other premium linked data types such as Geography, Currencies, and custom organizational data types are also exclusive to Microsoft 365 and unavailable in Excel 2021.
Can I import stock data in Excel 2021 without the data type feature?
Yes. You can use the 'From Web' feature found in the Data tab (Power Query) to import stock tables from financial websites manually, though it won't be as seamlessly integrated as the native Stocks data type.
Does Excel for the web have the exact same Stocks features as Microsoft 365?
No. While Excel for the web provides basic access to convert text into Stocks, it may have fewer capabilities, less frequent data refreshes, and fewer extractable data fields compared to the fully-featured desktop application.
