Fix Excel Stocks Data Type Not Refreshing Stock Prices
Question details
Resolve Excel Stocks data types that are not refreshing stock prices and continue to show an old Last Trade Time after manual refresh or in a new workbook.
- Product
- Microsoft Excel Stocks data type
- Device & OS
- Windows and Mac
- Scenario
- The user relies on Excel Stocks data types to track stock prices and tries to refresh the workbook manually or by creating a new file.
- Observed behavior
- Stock prices do not refresh; the Last Trade Time remains old even after refresh or in a new workbook.
Before troubleshooting, check the Microsoft 365 service health status for Stocks data types and note your Office version and update channel, because this is a known service-side issue.
Check Microsoft 365 service health for Excel Stocks data types
Use this first to verify whether the failure is a known Microsoft service-side issue before changing your Office installation.
Excel Stocks data types rely on Microsoft 365 cloud services. When the service has an incident, no local Office update or workbook refresh can force new stock prices to appear.
In a web browser, sign in to the Microsoft 365 admin center and go to Health > Service health, or open the Microsoft 365 service status page for your account.
Look for any active incident or advisory mentioning Excel, Stocks data types, or linked data types.
Open the primary Microsoft support discussion for “Excel Stocks data type not refreshing” and check the latest Microsoft agent response for status updates.
Update Office and contact Microsoft Support if the issue continues
Use this after confirming the service is healthy but the Stocks data type still fails to refresh.
Work in WPS Office When Excel Stocks Data Types Are Down
Excel Stocks data types depend on Microsoft’s cloud service, so the refresh failure is not something WPS Office can repair inside Excel. If you need to keep working with workbooks while the Stocks service is unavailable, WPS Office is a free, lightweight Office alternative that opens and edits Excel files with a familiar interface.
Frequently Asked Questions
Why is my Excel Stocks data type not updating stock prices?
This is usually caused by a Microsoft 365 service-side issue affecting Stocks data types in Excel for Windows and Mac, not by your workbook or Office version. Manual refresh will continue to show an old Last Trade Time until Microsoft restores the service.
How do I check if Excel Stocks data types are affected by a Microsoft service issue?
Sign in to the Microsoft 365 admin center and go to Health > Service health, or open the Microsoft service status page, then look for an advisory or incident that mentions Excel Stocks data types or linked data types.
Does updating Microsoft Office fix the Stocks data type refresh problem?
It can help if the service is already healthy and your Office installation is outdated. In Excel, go to File > Account > Update Options > Update Now, restart Excel, then select the Stocks cell and choose Data > Refresh All.
Will WPS Office refresh Excel Stocks data types?
No. WPS Office does not fix Microsoft’s cloud-linked Stocks data type service. However, WPS Office can open and edit your Excel workbooks in .xlsx format as a free alternative while you wait for the Microsoft service to recover.
