'%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 Prices Not Updating or Refreshing
Question details
Excel's built-in stock data types are failing to refresh or update with the latest market prices for several days.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to retrieve real-time or updated financial market data using the Excel Stock data type feature.
- Observed behavior
- Stock prices remain stale and do not refresh, likely due to an ongoing service outage with Microsoft's financial data providers.
Verify that your internet connection is stable and ensure you are actively signed into your Microsoft 365 account, as the Stock data type requires an online connection to function.
Check Microsoft 365 Service Health and Status
Verify if there is a known outage with Microsoft's data providers affecting the stock data types.
Excel relies on external financial data providers to populate its Stock data types. When these third-party services experience downtime, Excel cannot pull the latest market prices.
Open your web browser and navigate to the official Microsoft 365 Service Health status page.
Check the list of active alerts to see if there are any ongoing issues related to Excel connected experiences or external data providers.
If an outage is confirmed, you will need to wait until Microsoft engineers and their data partners restore the service. Estimated resolution times are often not provided for external provider issues.
Report the Issue via Excel Feedback
Send a direct report to the Office development team to help them prioritize fixing the prolonged data outage.
Try WPS Office for Your Spreadsheet Needs
While waiting for Microsoft to resolve its external data provider outages, consider trying WPS Office. It provides a lightweight, highly compatible, and free alternative for managing your daily spreadsheet and data analysis tasks.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and click 'Open' to select your existing Excel workbook.
- 3. Analyze Your Data: Continue working with your financial data using WPS Office's powerful built-in calculation and charting tools.
Frequently Asked Questions
How do I manually refresh stock prices in Excel?
To manually refresh your data, go to the 'Data' tab on the Excel ribbon and click 'Refresh All'. Alternatively, you can right-click a cell containing a stock data type and select 'Data Type' > 'Refresh'.
Why does Excel say I need a subscription for Stock data?
The Stocks and Geography data types are premium connected experiences. You must have an active Microsoft 365 subscription and be signed in to your account with internet access to utilize them.
How often do Excel stock data types normally update?
When the service is fully operational, stock data types can be updated on demand or when opening the file. Keep in mind that the financial data provided is typically delayed by about 15 minutes depending on the specific stock exchange rules.
