'%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)
Why the Stocks Data Type Is Missing in Excel LTSC & How to Fix It
Question details
Users are unable to find or use the Stocks and Geography data types within the Data tab in Microsoft Excel LTSC.
- Product
- Microsoft Excel LTSC
- Device & OS
- not provided
- Scenario
- Attempting to utilize connected data types like Stocks or Geography to automatically pull financial or geographic data into a spreadsheet.
- Observed behavior
- The Stocks and Geography data types are entirely missing from the Excel interface because these connected experiences are intentionally excluded from the LTSC edition.
Verify your exact Microsoft Office version by navigating to File > Account in Excel to confirm whether you are using a perpetual LTSC release or a Microsoft 365 subscription.
Upgrade to a Microsoft 365 Subscription
The only native way to restore the Stocks and Geography data types is to switch to a cloud-connected edition of Microsoft Excel.
Excel LTSC (Long Term Servicing Channel) is designed for specialized, disconnected environments. As a result, Microsoft intentionally excludes cloud-connected experiences, including the Stocks and Geography data types.
To utilize these features, you must use a Microsoft 365 subscription edition that natively supports continuous cloud connectivity.
Open Excel, click on 'File' in the top-left corner, and select 'Account'. Look under 'Product Information' to verify your current license type.
Purchase or subscribe to an eligible Microsoft 365 plan (such as Personal, Family, or an Enterprise plan) from the official Microsoft website.
Download the new Microsoft 365 installer, run the setup, and sign in with your newly licensed Microsoft account to activate the cloud-connected version of Office.
Once installed, launch the new Excel, navigate to the 'Data' tab on the ribbon, and locate the 'Data Types' group to use the Stocks and Geography features.
Use Power Query to Import Stock Data Manually
If you cannot upgrade from Excel LTSC, you can manually pull financial data from free web sources using the built-in Power Query feature.
Try WPS Office for Your Spreadsheet Needs
If you are frustrated by licensing restrictions and missing features across different Microsoft Office editions, consider switching to WPS Office. WPS Spreadsheet is a highly compatible, lightweight, and completely free alternative that helps you manage your financial data effortlessly.
- 1. Download the software: Visit the official WPS Office website and click the download button to get the free installer.
- 2. Install WPS Office: Run the installer file and follow the quick on-screen instructions to set up the software on your computer.
- 3. Open your spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing Excel workbooks to continue your data analysis without compatibility issues.
Frequently Asked Questions
What are connected experiences in Microsoft Excel?
Connected experiences are features that rely on cloud-based services to analyze your content or provide rich data updates. Because they require ongoing cloud connectivity to servers (like pulling live financial metrics), they are intentionally excluded from offline, perpetual licenses like Excel LTSC.
Can I add the Stocks data type to Excel LTSC using a third-party add-in?
No, the native Microsoft Stocks and Geography data types cannot be added to Excel LTSC via standard add-ins. You must either upgrade to a Microsoft 365 subscription or use specialized third-party financial API add-ins to fetch market data differently.
Is there a way to refresh stock data automatically without the native data types?
Yes. If you use the 'From Web' Power Query method to import stock data, you can set the query to refresh automatically. Simply click on 'Connections' under the Data tab, go to 'Properties', and check the box for 'Refresh every X minutes' to keep your financial data current.
