'%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 Stock Quotes Feature Missing in Specific Workbooks
Question details
The user is unable to access the Excel Stock Quotes feature in a specific workbook, while the feature works perfectly in a different workbook open on the same computer.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Comparing two legacy Excel workbooks where one successfully fetches stock data while the other cannot access the feature.
- Observed behavior
- The Stock Quotes feature is unavailable or missing in the second workbook, which lacks the legacy MSN MoneyCentral Investor Stock Quotes connection found in the working file.
Ensure you have an active internet connection and are signed into a Microsoft 365 account, as modern stock data retrieval requires active cloud services to function.
Upgrade Workbook Format and Apply Modern Data Types
Legacy workbook formats (like those from Excel 2010) often disable modern features. Saving the file in the newest format allows you to use the built-in Stocks data type.
The original workbook likely relied on the deprecated MSN MoneyCentral Investor Stock Quotes connection. Upgrading the file format to the current standard enables Excel's modern, built-in Stocks data type, resolving the missing feature issue.
Open the problematic workbook, click on 'File', select 'Save As', and choose 'Excel Workbook (*.xlsx)' from the format dropdown menu to ensure compatibility with modern data features.
Navigate to the 'Data' tab on the ribbon and click on 'Queries & Connections'. Review the list to confirm if legacy web query connections are missing or broken.
Select the cells containing your company names or ticker symbols, go to the 'Data' tab, and click on 'Stocks' in the 'Data Types' gallery to fetch updated financial information.
Migrate Data to a New Blank Workbook
If upgrading the file format does not restore the Stocks feature, the old workbook may contain background corruption or persistent legacy compatibility settings.
Try WPS Office for Seamless Spreadsheet Management
Struggling with missing features, legacy format compatibility issues, and deprecated data connections in Microsoft Excel? WPS Office provides a lightweight, highly compatible alternative for managing your financial data, complex spreadsheets, and daily office tasks.
Frequently Asked Questions
Why is the Stocks data type greyed out in my Excel workbook?
The Stocks feature may be greyed out if your workbook is saved in an older 'Compatibility Mode' (.xls), if you are currently offline, or if you are not signed into a Microsoft 365 account with the necessary subscription.
Can I still use the MSN MoneyCentral Investor Stock Quotes connection?
No, Microsoft has officially deprecated the MSN MoneyCentral Investor web query connection in newer versions of Excel. You must update your tracking methods to use the modern 'Stocks' data type found in the Data tab.
Does the modern Stocks feature work on older versions like Excel 2010?
The modern Stocks data type is exclusive to Microsoft 365 and newer standalone versions of Excel. Excel 2010 relied entirely on legacy web queries that are no longer supported or updated.
How do I know if my workbook is stuck in Compatibility Mode?
Look at the very top of your application window. If you see '[Compatibility Mode]' displayed next to your file name, the workbook is using an older file format which restricts newer data tools.
