Forum Discussion
Excel 365 Stock Data not updating all stocks
I checked a simple worksheet that I set up a few days ago:
The data is NOT changing. Refresh does nothing. Stuck at 4/17 it appears.
So, I added the same structure using a new symbol and "Stocks" and got what appears to be current data. But it too does not update. Makes one think there is an Excel bug if the data is indeed available.
Ssounds like you're running Excel 16.72 (a recent update). Current version of Ventura 13.3.1 coupled with Excel 16.71 works. After this multi-month debacle occurring multiple times, I turned off auto-updates and will only update my primary system after testing any Mac OS and Excel updates on a secondary laptop. So by process of elimination, assuming nothing else has changed on your system, it's probably the 16.72 that broke the data call. If you can roll back to 16.71, you'd probably be ok (there are various ways to roll back--check the thread higher up--that might help). fcm339