Results 1 to 7 of 7

Thread: How do I get the Stocks data type?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2005
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How do I get the Stocks data type?

    I don't see "Stocks" on the Data menu. I understand that the Stocks data type is only available to Office 365. I'm not 100% sure if
    I'm running Office 365 or not. I go to File --> Account --> About Excel, and it says "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit". Is this not Office 365?

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,837
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How do I get the Stocks data type?

    I don't think you'll find name "Stock" in Excel or even in PowerBi
    You need to choose appropriate kind of service for that
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,255
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How do I get the Stocks data type?

    You should find it under the DATA Menu. It does say STOCKS. You may need to check that you have the latest ver. See below link to Office Support. They say this came out in the March 2019 update.

    https://support.office.com/en-us/art...0-623cf07fbc54

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,837
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How do I get the Stocks data type?

    Quote Originally Posted by AhoyNC View Post
    You may need to check that you have the latest ver. See below link to Office Support. They say this came out in the March 2019 update.
    Thanks AhoyNC, update is required
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  5. #5
    Board Regular
    Join Date
    May 2005
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How do I get the Stocks data type?

    So, is "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit" the right version or not? There does not appear to be a date associated with it.

    ETA: I am using Office for PC.
    Last edited by Mr. Snrub; Jun 21st, 2019 at 04:43 PM.

  6. #6
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,837
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How do I get the Stocks data type?

    maybe this is available for ProPlus
    https://support.office.com/en-us/art...6-6ff6118f8293
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  7. #7
    Board Regular
    Join Date
    May 2005
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How do I get the Stocks data type?

    UPDATE! My IT administrator just updated all of our versions of Excel, and now I've got "Microsoft Excel for Office 365 MSO (16.0.11328.20362) 32-bit", and now I have Stocks in the Data tab!!!!! Woo hoo!!!!!!!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •