'%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 into Linked Stock Data?
Question details
The user wants to know if they can convert text into linked stock data using Excel 2021 Professional.
- Product
- Microsoft Excel 2021
- Device & OS
- not provided
- Scenario
- Attempting to use the Stocks data type to fetch live financial information and stock market metrics.
- Observed behavior
- The linked Stocks data type feature is missing and unavailable in the perpetual Excel 2021 license.
Verify your current Microsoft Office version and ensure you have an active internet connection, as linked data types require online services to fetch third-party financial data.
Use Excel for the Web
Since Excel 2021 lacks this feature natively, using the free web-based version of Excel is the most accessible way to utilize the Stocks data type.
Excel for the web provides access to many cloud-connected features that are absent in perpetual desktop licenses, including the linked Stocks data type.
Open your web browser, navigate to the Microsoft 365 website, and sign in with your free Microsoft account.
Click on the Excel icon to create a new blank workbook, or upload your existing Excel 2021 file to OneDrive.
Type the company names or ticker symbols into a column of cells and highlight them.
Go to the Data tab on the top ribbon and click on 'Stocks' in the Data Types group to convert your text into linked data.
Upgrade to a Microsoft 365 Subscription
To use linked data types directly within the desktop application, you must switch from a perpetual license to a subscription model.
Try WPS Office for Your Spreadsheet Needs
If you are frustrated by the licensing restrictions and missing features in perpetual Office versions, WPS Office offers a lightweight, highly compatible, and free alternative. Enjoy a familiar interface and comprehensive spreadsheet tools without expensive subscription fees.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the application: Run the installer and follow the simple on-screen instructions to set up WPS Office on your device.
- 3. Open your spreadsheets: Launch WPS Spreadsheet to open, edit, and analyze your existing Excel files seamlessly.
Frequently Asked Questions
Why is the Stocks data type missing in Excel 2021?
Excel 2021 is a perpetual (one-time purchase) license. Microsoft reserves certain premium, cloud-connected features—like the Stocks data type, which pulls live data from third-party online services—exclusively for Microsoft 365 subscribers.
Can I buy the Stocks data type as an add-on for Excel 2021?
No, Microsoft does not offer the linked data types as a separate add-on. You must either use the free Excel for the web version or upgrade to a full Microsoft 365 subscription.
Are there other linked data types unavailable in Excel 2021?
Yes. Along with Stocks, other linked data types such as Geography, Currencies, and custom organization data types are also restricted to Microsoft 365 subscribers and are not natively available in Excel 2021 Professional.
How do I know if my Excel web version supports Stock data?
Log into Excel for the web with your Microsoft account, go to the 'Data' tab, and look for the 'Data Types' group. If 'Stocks' is visible, your current region and language settings support the feature.
