Forum Discussion
excel 365 not updating stock prices, retreives only prior day close
Windows 11 based machine with microsoft 365, my spreadsheet worked great until yesterday, tech help had a workaround which did work yesterday, but not today. Won't retreive price, $ change and % change, shows description. The refresh all under data tab doesn't do the trick. Please help.
35 Replies
the problem is back again since 15 May 2025 and no update from mincrosoft. ASX stocks not working on an price updates
My issue is an error message...." You need to sign in with an account associated with a subscription to use these data types" Going on two days now....5CupsOfCoffee
- When trying to "refresh", I get the message "You need to sign in with an account associated with a subscription to use the data types. Select Microsoft Excel fromthe top menu > Sign in".
I have already tried to log out and the again log in: same situation. It doesn't work!
As already mentioned here above, its likely to be a Microsoft issue. Lets cross the fingers for a rapid solution.- Chatting with Excel Support. They said Microsoft is aware of the issue and is working on resolving it.
5CupsOfCoffee
I'm experiencing the same problem since yesterday evening.
Is anyone else experiencing the same?Many thanks for your reactions.
philippedevos , I am experiencing the same on my desktop app. Message when refreshing data is to check I am logged in with an account that has a subscription. Of course I do have an active 365 subscription, and when I use the online version of excel it works like a charm. Looks like MS inadvertently patched or modified something that broke the desktop access.
rong007, is it possible to use an excel file on my computer with the online version of Excel, so that I can get access to those stock quotes?
- Same. But in addition Excel is reporting that I need to 'check my refresh settings' because I'm not logged in - when I am in fact logged in. I've tried signing out and then back in - no joy. So it appears there is something wrong (again) at Microsoft's end.
- I am having the same problem today - Monday March 20 2023. Whiskey Tango Foxtrot!
Some stocks and ETFs are working this morning March 20, 2023, but others are NOT WORKING. What I see as NOT WORKING this morning are:
AMD
SCHW
LMT
Are those working for anyone else? My last update is Friday March 17, 2023 for those. Does anyone else have any other stocks, etfs and/or indexes that are NOT WORKING?
I am an Office 365 user on a Mac. Started experiencing sporadic freezes on 3/16/23. Spoke with Microsoft Tech Department yesterday morning for nearly one hour. Apparently not on their radar at that time. This morning had no activity with stock price capability. Called Tech Dept. again today and was advised they were aware of the problem and would provide me information by email to receive their update notifications. Unfortunately, I haven't received the email at this writing. It was described to me as a system wide problem with this service. If anyone has the link to receiving notifications, kindly advise.
Thank you.
- Some of the data are updating now but some are not. As of 6:00 pm EDT, AMD is updated but ADBE is not; CLF is updating and FCX is not. It looks like we'll just have to wait. I wouldn't be surprised if MSFT wasn't playing with this service and trying to get ChatGPT involved somehow. And broke something.
I have 50 stocks. I sorted my Excel Stocks data by Symbol, copied the column and pasted it to GoogleSheets. I then used the GoogleFinance() operator to obtain quotes this evening. I then copied the data column in GoogleSheets and pasted it to my Excel table column labled Price today. I reformatted the data in the Excel column to Currency. I did not have to change any of the formulas in my Excel Table.
- Same here. I use it for Brazilian market, I suppose it is happening everywhere... Problem happened yesterday too.
- U.S. markets have just closed, and no resolution. Come on, Microsoft, what the heck!
5CupsOfCoffee Same issue as of 3/17 3:30 Eastern.
- Same problem - stocks prices are falling and we are observing yesterday's close. Refreshall does not work - nothing is upating.
5CupsOfCoffee I reported this issue to Microsoft Support. They said they would report it to their engineers and get back to me.
- Same problem.
thanks - glad to learn I'm not the only one
