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

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

3 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.