Stocks & Geography not showing up under Data Types

Copper Contributor

I have Microsoft Office Home and Student 2019 since 2019.

Made a up front one-off payment via Microsoft for personal user (No ongoing annual fee)

I get regular updates so it is pretty much up to date.

My Excel question relates to the missing Stocks and Geography items under Data Types.

I am looking for a way to add some FOREX PAIRS (eg USD / GBP into a spread sheet which apparently can be done via the Stocks menu).

Can someone explain why I am missing the Stocks and Geography menus or alternatively how I can get them included.

4 Replies

@Christopher1945 I understand these features are only supported in MS365 (subscription), Excel for the Web and possibly also Excel 2021.

Thanks for that - I thought that might be the only reason
Hi I have subscription for MS365 and using MS Office Professional Plus 2021. Data Types is showing but Empty. please help.

@Pradeep1760 This is what the MS support pages say about it:

Screenshot 2023-10-27 at 07.16.48.png

and you must have 'Connected experiences' enables. More about that in the link below.

https://support.microsoft.com/en-us/office/connected-experiences-in-microsoft-365-8d2c04f7-6428-4e6e...