Forum Discussion

andys68's avatar
andys68
Copper Contributor
Jul 11, 2023
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?

 

  • andys68 

    This is an ongoing problem. See if you can refresh the quotes in the online (browser) version of Excel in Microsoft Edge.

29 Replies

    • charlesdoran-ria's avatar
      charlesdoran-ria
      Copper Contributor

      JeffCrane 

      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.

  • tzhang31's avatar
    tzhang31
    Copper Contributor
    I 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...
  • Steve1330's avatar
    Steve1330
    Brass Contributor
    I've had the same problem, starting yesterday and again today. Thanks.
  • andys68 

    This is an ongoing problem. See if you can refresh the quotes in the online (browser) version of Excel in Microsoft Edge.

    • meeee725's avatar
      meeee725
      Copper Contributor
      Thank 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_Palomo's avatar
        M_J_Palomo
        Copper 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 

    • andys68's avatar
      andys68
      Copper Contributor
      HI Hans, that seems to work. I guess I will need to work like this until Microsoft resolve the issue.
      Many thanks for your help.

Resources