Stocks won't refresh in Excel

Question

Stocks not updating in Microsoft 365 for the last several days

Answer 1

If the Stocks data type in Excel is not refreshing, it could be due to various reasons such as connectivity issues or problems with the data source itself. Here are a few steps you can take to troubleshoot the issue:

1. Check Internet Connection: Ensure that your internet connection is stable, as the Stocks data type requires an active connection to update.
2. Refresh the Data: Try manually refreshing the Stocks data by selecting the cell with the Stocks data type and clicking on the refresh option.
3. Re-enter the Data Type: Sometimes, removing the Stocks data type and reapplying it can resolve issues. You can do this by selecting the cell, going to the Data tab, and choosing the Stocks data type again.
4. Check for Updates: Make sure that your version of Excel is up to date, as updates can fix bugs and improve functionality.
5. Contact Support: If the problem persists, consider reaching out to Microsoft support for further assistance.

These steps should help you resolve the issue with Stocks not updating in Excel.

Answer 2

Thanks for sharing the details! Try to force Excel to Rebuild the Stock Data Cache

Excel caches stock entity data locally, and when that cache corrupts, refresh silently fails.

Steps

• Close Microsoft Excel
• Press Win + R
• Paste:
  %localappdata%\Microsoft\Office\16.0\Wef\
• Delete everything inside this folder
• Reopen Excel and refresh

See if this helps. If you need further assistance just let me know.

Best regards,

Kimberly