Forum Discussion
Excel 365 Stock Data not updating all stocks
Fredward Is there a way within your spreadsheet to see when it was last updated?
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
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.
- Yep...mine is now working...would have preferred the down time to be today (Saturday), not in the middle of the open market.
- Go figure. I opened my file just now and it updated (3/18/2023 00:00). Hopefully they figured it out and we are good moving forward.
- Nice thanks!! (3/16/2023 23:52 is my last showing update)
- We are so out of luck...after a half hour in chat with MS, they simply acknowledge there's a problem, but there are no workarounds that they could offer, just that they will contact me once they have more info.
