Stock Rfresh is not showing latest value

Hi, Debadatta Rout

Excel’s stock values can also get stuck if the ticker is matched to the wrong instrument, the workbook cache is stale, or Excel’s online data service is having a temporary issue.

Besides the solutions provided by the Q&A Assist, here are some suggestions you can try:

First, select XNSE:ASIANPAINT, open the stock card, and check the exchange/source shown at the bottom. If it does not clearly show NSE/National Stock Exchange, delete the linked stock and add it again using the exact code XNSE:ASIANPAINT.

It is also suggested that you test the same ticker in Excel for the web. If it updates there but not in desktop Excel, sign out of Excel, close it, reopen it, sign back in, then update Office from File > Account > Update Options.

If only this workbook is affected, copy the ticker list into a new blank workbook and convert them to Stocks again. If all tickers are stuck, it may be a service-side issue, so use Help > Feedback in Excel and include the ticker, wrong value, and your region.

Thank you for your patience in reading, I hope this information has been helpful to you. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Stock and other financial data in Excel 2024 comes from an external provider and is not real-time. Prices are delayed and provided “as-is,” so they will often differ from the current live market price shown on broker or exchange sites. This is expected behavior and the data is not intended for trading or real-time decision making.

To ensure the workbook is using the latest data available from the provider:

1. Confirm the cells are using the Stocks linked data type (they should show the stock icon in the cell).
2. To refresh a single linked data type:
   • Right-click the cell with the stock data.
   • Select Data Type > Refresh.
3. To refresh all linked data types and other connections in the workbook:
   • Go to Data > Refresh All, or
   • Press Ctrl+Alt+F5.

If the refresh completes almost instantly and values do not change, it usually means:

• The external provider has not updated the underlying data yet, or
• The existing values are already the latest available from that provider.

If persistent refresh errors appear (message bar, dialog, or tooltip), use the guidance for linked data type refresh errors, including temporarily turning off Automatic Refresh and then manually refreshing after conditions are resolved.

For historical prices instead of the latest quote, use the STOCKHISTORY function, which also relies on the same financial data provider.

References:

• About the Stocks financial data sources
• Excel data types: Stocks and geography
• Get a stock quote
• Get help with linked data type refresh errors
• Refresh an external data connection in Excel
• Excel help & learning