Forum Discussion
Solved
Refreshing stock prices in Excel has stopped working - asking for account with subscription
Hi,
My excel with automatically updating share prices stopped working yesterday. I thought it was a blip, but still not working today.
I'm getting the following message:
'COULDN'T REFRESH DATA TYPES you need to sign in with an account associated with a subscription to use these data types '
I am signed in to my Office365 account and nothing has changed. Do we now need to subscribe/pay for share data or is there something else?
This is an ongoing problem. See if you can refresh the quotes in the online (browser) version of Excel in Microsoft Edge.
- Wish Microsoft would do a better job of communicating the status of these problems!
- The issue appears to be fixed this morning (UK time!). Thanks everyone for your valuable contributions and workarounds!
- I've had the same problem for several days. I tried rebooting, signing out and back in, all to no avail. What did finally work was starting Excel in safe mode (run excel.exe /safe) and loading my stock sheet. The data has been updating so far, even when running Excel normally on the desktop. Hope it keeps working!
fiddlcat looks like the problem is fixed this morning, my sheet updated the second I opened it
- It's working for me too..thanks everyone!
- Thanks, I downloaded and tried the online version and it worked once for the first file. Didn't work on my second file and now won't update the first file. I'm 74 and maybe have done something wrong. Annoying.
- somewhere in the exel program, i found Contact Us...or maybe it was Contact Microsoft. I clicked on a few links, and finally go the option to have them call me, or to do an online chat. I chose online chat. I was 3rd in the queque, and only had to wait about 5 minutes to chat with a real person.
- Having the same issue - is driving me crazy, Web based excel works fine.
- Thank you for this thread! I opened up my Spreadsheet in Edge/Online Excel, which copied it up to OneDrive and set auto-save to ON. Then when the online version is "refreshed" - which WORKS!! WHOOHOO! - the version on my hard drive is also updated (per the auto-save option). So... when I drop offline, my local version will also be updated. I hope MS fixes the issue on this. I travel often and can't work online in most of my client sites. But for now, at least there is a work-around (annoying, but it works).
TinaT_33 I tried the same workaround, but receive the same message in the online version as I do in the desktop version. It might be due that I am in Canada, however.
- TinaT
That's a great workaround! Worked for me too. Hope MSFT get this properly fixed ASAP!!
- Same issue here. Mine broke yesterday. I tried accessing my spreadsheet from my laptop and it had the same problem. Nothing has changed on either my PC nor my laptop. So, it has to be an issue at MSFT that needs to be addressed.
