Fix Excel Stock Data Type Errors (#NAME? or #UNKNOWN) on Mac
Question details
Users need to resolve #NAME? or #UNKNOWN errors when attempting to use Stock Data Types in Excel for Mac without an active Microsoft 365 subscription.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Pulling financial and stock market information into an Excel spreadsheet using the built-in linked Stock Data feature.
- Observed behavior
- Stock data fields generate #NAME? or #UNKNOWN errors, and the feature fails to add columns after an Office update, despite working previously.
Ensure your Mac is connected to the internet and verify your current Office license type (Microsoft 365 subscription vs. one-time purchase) under the 'About Microsoft Excel' menu.
Verify Office License and Microsoft 365 Subscription
Confirm whether your account has an active Microsoft 365 subscription, which is strictly required to use Linked Data Types like Stocks.
The Stock Data Type is an exclusive premium feature for Microsoft 365 subscribers. A past Office update incorrectly enabled this feature for one-time purchase users (such as Office Home & Student 2021). Microsoft subsequently patched this bug, which caused previously working stock data to revert to #UNKNOWN or #NAME? errors for non-subscribers.
Launch Microsoft Excel on your Mac. Click on 'Excel' in the top Apple menu bar, then select 'About Microsoft Excel'.
Look for the 'License' field in the pop-up window. Check if it reads 'Microsoft 365 Subscription' or 'Office 2021' (or similar one-time purchase).
If you have a one-time purchase license, you must upgrade to a Microsoft 365 subscription to restore the built-in Stock Data functionality, or rely on manual web data imports via CSV files.
Try WPS Office as a Free and Powerful Spreadsheet Alternative
Avoid subscription paywalls and unexpected feature removals. WPS Office offers a completely free, lightweight, and highly compatible alternative to Microsoft Office, letting you manage complex spreadsheets effortlessly.
- 1. Download WPS Office: Visit the official WPS website and download the Mac version of WPS Office.
- 2. Install and Open: Follow the installation prompts, open WPS Spreadsheets, and click 'Open' to load your existing financial workbooks.
- 3. Edit Without Subscriptions: Enjoy editing your formulas, charts, and data sets without worrying about hidden paywalls or sudden feature restrictions.
Frequently Asked Questions
Why did the Excel Stock Data Type work before on my Office 2021?
A previous Microsoft software update temporarily and incorrectly exposed this premium Microsoft 365 feature to users with one-time purchase licenses like Office 2021. A subsequent patch corrected this bug, removing access and causing the #UNKNOWN errors.
Can I fix the #NAME? error without buying a Microsoft 365 subscription?
No, the built-in Stock Data Type functionality is strictly locked behind a Microsoft 365 subscription. However, you can manually import stock data using standard web queries or by downloading and importing CSV files from financial websites.
What does the #UNKNOWN error mean in Excel?
The #UNKNOWN! error indicates that Excel does not recognize the data type being used in the cell. This commonly happens when you open a workbook containing linked data types (like Stocks or Geography) on a version of Excel that doesn't support them or lacks the necessary active subscription.
