'%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)
Does Excel 2019 for Mac Support Stocks and Geography Data Types?
Question details
The user wants to know if the Stocks and Geography linked data types are available or can be enabled in Microsoft Excel 2019 for Mac.
- Product
- Microsoft Excel 2019
- Device & OS
- Mac
- Scenario
- Attempting to use, add, or refresh workbooks containing dynamic Stocks and Geography data types on a Mac running Excel 2019.
- Observed behavior
- The Stocks and Geography data types are missing from the Data tab, and existing workbooks with these data types do not function properly after being downloaded and opened in Excel 2019.
Verify your exact Excel version by opening the application, clicking 'Excel' in the top Mac menu bar, and selecting 'About Microsoft Excel' to confirm whether you are running a perpetual 2019 license or a Microsoft 365 subscription.
Use Excel for the Web
Since Excel 2019 for Mac does not support premium linked data types, using the free web-based version of Excel is the best immediate workaround.
Microsoft makes the Stocks and Geography data types available in Excel for the Web for users with a free Microsoft account. You can seamlessly view, add, and refresh these data types online without needing a Microsoft 365 subscription.
Open your web browser, navigate to Office.com, and sign in with your free Microsoft account credentials.
Drag and drop your Excel workbook into the browser window, or click 'Upload' in OneDrive to save your file to the cloud.
Open the workbook in Excel for the Web, select your target cells, and navigate to the 'Data' tab on the ribbon to apply the Stocks or Geography data types.
Use Apple Numbers for Stock Data
If you strictly need to pull stock market data and do not want to use a web browser, Apple's built-in Numbers app for Mac is a capable alternative.
Upgrade to a Microsoft 365 Subscription
For full native desktop support of Stocks, Geography, and other rich data types, upgrading your standalone license to a subscription model is required.
Try WPS Office for High-Performance Spreadsheet Processing
If you are frustrated by the feature limitations of older Microsoft Office versions like Excel 2019, WPS Office provides a lightweight, highly compatible, and free alternative. It offers powerful data analysis tools, cross-platform support, and a familiar interface without requiring expensive monthly subscriptions.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for macOS.
- 2. Install the Application: Open the downloaded DMG file and drag the WPS Office icon into your Applications folder.
- 3. Open Your Spreadsheets: Launch WPS Office and directly open your existing Excel workbooks seamlessly to continue your work.
Frequently Asked Questions
Why are Stocks and Geography data types missing in Excel 2019?
Microsoft restricts dynamic, cloud-backed linked data types to Microsoft 365 subscribers. Standalone perpetual licenses like Excel 2019 and Excel 2021 do not receive these ongoing feature updates.
Will Excel 2019 for Mac ever get the Stocks and Geography feature?
No, Excel 2019 is a perpetual license product that only receives security and stability updates. New feature additions, including premium data types, are entirely reserved for subscription versions.
Can I view a workbook with Stocks data in Excel 2019?
You can open the workbook, and you might see the last saved text values in the cells. However, you will not be able to refresh the data, extract new fields, or interact with the data type cards because the underlying engine is unsupported.
Does Excel 2021 for Mac support these data types?
No, Excel 2021 is also a perpetual standalone release. Just like Excel 2019, it does not include the Stocks and Geography data types, which remain exclusive to Microsoft 365 and Excel for the Web.
