'%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)
Fix Excel Stocks Data Type Missing in Office LTSC 2024
Question details
The user wants to know if the Stocks and Geography linked data types are available in Microsoft Office LTSC Professional Plus 2024.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Migrating to a one-time purchase perpetual license or checking feature availability after installing Office LTSC 2024.
- Observed behavior
- The Stocks and Geography data types are missing from the Excel Data tab and cannot be used.
Verify your current Microsoft Office license type by navigating to File > Account in Excel to confirm whether you are using a Microsoft 365 subscription or a perpetual license like Office LTSC 2024.
Upgrade to a Microsoft 365 Subscription
The Stocks and Geography data types require Microsoft 365-connected services and are not included in perpetual licenses.
Excel's linked data types (such as Stocks and Geography) rely heavily on cloud-connected services provided exclusively through Microsoft 365. One-time purchase editions, including Office LTSC Professional Plus 2024, do not support these dynamic data types.
If you are moving from a Microsoft 365 subscription to Office LTSC Professional Plus 2024, these features will automatically be removed from your Excel application.
Open Excel and click on the 'File' tab in the top-left corner, then select 'Account' at the bottom of the menu.
Look under 'Product Information' to see if your license indicates Microsoft 365 or a perpetual version like Office LTSC 2024.
If you require the dynamic Stocks and Geography data types, you must purchase and activate an eligible Microsoft 365 subscription instead of a standard perpetual Office license.
Use External Financial Data Imports
If you must remain on Office LTSC 2024, you can manually import stock data from the web.
Try WPS Office for a Feature-Rich Spreadsheet Experience
If upgrading to a costly Microsoft 365 subscription isn't an option, consider WPS Office. It provides a lightweight, free alternative to Microsoft Office with high compatibility for standard Excel formats and powerful data analysis tools.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the Suite: Run the installer and follow the quick on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks to resume your data analysis without subscription fees.
Frequently Asked Questions
Why did my Stocks data type disappear in Excel?
If you recently switched from a Microsoft 365 subscription to a perpetual license like Office LTSC 2024 or Office 2021, the dynamic linked data types (Stocks and Geography) are removed. They require continuous cloud-connected services exclusive to Microsoft 365.
Will the Stocks data type ever be added to Office LTSC 2024?
No, Microsoft has stated that linked data types rely on premium cloud services, which are not included in standard one-time purchase perpetual licenses like Office LTSC 2024.
Can I view spreadsheets with existing Stocks data in Office LTSC 2024?
Yes, you can view the static data that was previously fetched and saved in the workbook. However, you will not be able to refresh the data or convert any new text into the Stocks data type.
