Forum Discussion
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.
29 Replies
- JeffCraneCopper Contributor
Same problem for me today.
- charlesdoran-riaCopper Contributor
I have experienced the same issue on several worksheets I have also tried with/without a VPN with no success. To summarize I am being told by an error message to sign-in, despite being signed in.
- tzhang31Copper ContributorI have also got the same problem since a few hours ago, and tried to restart my PC a few times, and reset my office subscription a few times. But the problem is still there...
- GraemeFrancisCopper ContributorAlso same problem, started today 😞
- Steve1330Brass ContributorI've had the same problem, starting yesterday and again today. Thanks.
This is an ongoing problem. See if you can refresh the quotes in the online (browser) version of Excel in Microsoft Edge.
- meeee725Copper ContributorThank you for responding, I have the same issue. Talked with a microsoft tech, he said there is a "bug" and people are working on it.
I hate to be a pain, but could you please explain, set by step, how to access the online version of Excel in Microsoft Edge? Thank you much, I owe you a beer.- M_J_PalomoCopper Contributor
I have my files saved on One Drive. If you go to One Drive on the web you can access all your files including Excel files. Just click on the file you want to use and it will open on the web based version of Excel. In the web version of Excel the stockhistory function is working and any changes you make on your files can be downloaded to your computer. This will not solve the problem on the computer based version of Excel but at least you can get the information you want. meeee725
- andys68Copper ContributorHI Hans, that seems to work. I guess I will need to work like this until Microsoft resolve the issue.
Many thanks for your help.