Fix Excel Stock Data Type Blocked with Office 2021 License
Question details
The user receives a Blocked error message when attempting to query stock market values using the Stocks data type.
- Product
- Excel for the web
- Device & OS
- Ubuntu
- Scenario
- Attempting to use the Stock Data Type to fetch real-time financial data in Excel for the Web using an Office Professional Plus 2021 license.
- Observed behavior
- Excel blocks the feature because connected data types like Stocks are tied to Microsoft account types and are not supported on perpetual Office 2021 licenses.
Verify the exact Microsoft Office license you are currently logged in with, as connected data features depend entirely on your specific subscription type.
Switch to a Microsoft 365 Subscription Account
The Stock Data Type requires a Microsoft 365 subscription because it relies on connected premium services not included in perpetual licenses like Office 2021.
Perpetual licenses such as Office Professional Plus 2021 only include features available at the time of purchase. Live connected features require an active Microsoft 365 subscription.
Open Excel for the Web, click on your profile picture in the top right corner, and sign out of your Office Professional Plus 2021 account.
Log back into office.com using an account that has an active Microsoft 365 subscription.
Select the cells containing company names or ticker symbols, navigate to the Data tab, and click on Stocks in the Data Types group.
Use a Free Microsoft Account via Excel for the Web
If you don't have a Microsoft 365 subscription, you can access basic Stock features using a free personal Microsoft account on Excel for the Web.
Try WPS Office for Your Spreadsheet Needs
If Microsoft licensing restrictions are holding you back, WPS Office offers a free, lightweight, and highly compatible alternative. While live connected data types require specific premium Microsoft subscriptions, WPS Spreadsheet provides powerful data analysis tools and seamless compatibility with Excel formats.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing financial tracking .xlsx files directly.
- 3. Import stock data manually: Use standard CSV imports or external API tools to bring your stock market values into your spreadsheets without encountering license blocks.
Frequently Asked Questions
Why doesn't the Stock data type work on Office 2021?
Office 2021 is a perpetual (one-time purchase) license. The Stocks data type is a connected service that constantly fetches data from the internet, which Microsoft restricts to active Microsoft 365 subscriptions or free online accounts.
Can I use the Excel Stock data type natively on Ubuntu Linux?
Microsoft Excel does not have a native desktop application for Ubuntu. You must use Excel for the Web through a browser. Be aware that certain browsers on Linux may restrict features like manually refreshing data connections.
Is there a workaround to get stock data without upgrading my Microsoft license?
You can use a free personal Microsoft account on Excel for the Web to access basic stock data types, or you can manually import CSV files downloaded from financial websites like Yahoo Finance into your spreadsheets.
