Forum Discussion

DMHene's avatar
DMHene
Copper Contributor
Jan 13, 2023

Stock Price Function

I've used the "Stocks" Data Feature in the past. This is missing from Excel on my new Surface. It still works on an old desktop I have but not on my new Surface. I would expect more features, not less! If I need a different version of Excel, how do I manage that from O365?

 

Does anyone know how to fix this? 

6 Replies

  • RJ2's avatar
    RJ2
    Occasional Reader

    My stock button and all the stock functions disappeared on March 31. The prices froze from that day, and it won't update. The data tab looks different and doesn't have the data types box at all which has the stock button. Typing in stocks doesn't work either. Reinstall and repair didn't work. It works in a new profile account if I create one, but doesn't carry over to my main account. It works properly in excel online too, just not mine on my account. 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    DMHene 

    What exactly is your version/channel on Surface, if you are on 365? It's in File -> Account

    • DMHene's avatar
      DMHene
      Copper Contributor
      I think this is what you're asking, right?
      Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        DMHene 

        I guess this build belongs to retail version of Office 2021. You may check on same page (File->Account) on the top under Product information. It says is that subscription product and which one; or product activated and which one.

        If not subscription version is installed, Stocks is not available.

        However, if you have 365 subscription and it allows to install Office on up to 5 devices, you may download and install subscription version of the Office instead of 2021. If subscription allows only one installation - no way, only to upgrade your subscription.

        You may check your subscription options under your account information. Login to office.com in any browser and shift on account information.