excel data type stock and geography are not appearing under data head

%3CLINGO-SUB%20id%3D%22lingo-sub-2377682%22%20slang%3D%22en-US%22%3Eexcel%20data%20type%20stock%20and%20geography%20are%20not%20appearing%20under%20data%20head%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377682%22%20slang%3D%22en-US%22%3E%3CP%3Eexcel%20data%20type%20stock%20and%20geography%20are%20not%20appearing%20under%20data%20head%20after%20updating%20office%202019%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Portfolio.xlsx%20-%20Excel%2022-05-2021%2004_24_53%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282826iB870FDEADE6F02A0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Portfolio.xlsx%20-%20Excel%2022-05-2021%2004_24_53%20PM.png%22%20alt%3D%22Portfolio.xlsx%20-%20Excel%2022-05-2021%2004_24_53%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Portfolio.xlsx%20-%20Excel%2022-05-2021%2004_27_47%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282828i0C37650D83969951%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Portfolio.xlsx%20-%20Excel%2022-05-2021%2004_27_47%20PM.png%22%20alt%3D%22Portfolio.xlsx%20-%20Excel%2022-05-2021%2004_27_47%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2377682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2377716%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20data%20type%20stock%20and%20geography%20are%20not%20appearing%20under%20data%20head%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377716%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060577%22%20target%3D%22_blank%22%3E%40shubhamjangid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%20available%20only%20for%20the%20subscription%20model%20(Office%20365)%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20data%20types%3A%20Stocks%20and%20geography%20-%20Office%20Support%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EExcel%202019%20is%20not%20updated%20with%20new%20functionality%2C%20you%20need%20to%20wait%20for%20coming%20Excel%202021%20and%20purchase%20the%20upgrade.%20But%20Excel%202021%20also%20will%20be%20with%20%22fixed%22%20functionality%20till%20next%20Excel%202023%20or%20so.%3C%2FP%3E%0A%3CP%3EIf%20you'd%20like%20to%20have%20latest%20Excel%20functionality%20it's%20better%20to%20shift%20on%20subscription%20model.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2377832%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20data%20type%20stock%20and%20geography%20are%20not%20appearing%20under%20data%20head%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2377832%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20before%20updating%2C%20I%20was%20using%20that%20stock%20feature%20continuously%20for%205-6%20days%20after%20purchasing%20office%202019%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

excel data type stock and geography are not appearing under data head after updating office 2019Portfolio.xlsx - Excel 22-05-2021 04_24_53 PM.pngPortfolio.xlsx - Excel 22-05-2021 04_27_47 PM.png

4 Replies

@shubhamjangid 

It is available only for the subscription model (Office 365) Excel data types: Stocks and geography - Office Support (microsoft.com)

Excel 2019 is not updated with new functionality, you need to wait for coming Excel 2021 and purchase the upgrade. But Excel 2021 also will be with "fixed" functionality till next Excel 2023 or so.

If you'd like to have latest Excel functionality it's better to shift on subscription model.

 

 

 

@Sergei Baklan 

but before updating, I was using that stock feature continuously for 5-6 days after purchasing office 2019

@shubhamjangid 

Sorry, I have no idea. Officially data types are not supported for 2019.

It is not in my Excel 2021 version. I customized the ribbon to add a new group Data Types but the choice is grayed / unavailable. Wonder if I need to turn on something but can't find what.

The data type I want is stock prices. Interestingly, Google includes the function GOOGLEFINANCE() in GoogleSheets which is free.   Unfortunately, I know Excel and not sure I want to learn Sheets.