Forum Discussion
Stocks & Geography not showing up under Data Types
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
- Riny_van_EekelenPlatinum Contributor
Christopher1945 I understand these features are only supported in MS365 (subscription), Excel for the Web and possibly also Excel 2021.
- Pradeep1760Copper ContributorHi I have subscription for MS365 and using MS Office Professional Plus 2021. Data Types is showing but Empty. please help.
- Riny_van_EekelenPlatinum Contributor
Pradeep1760 This is what the MS support pages say about it:
and you must have 'Connected experiences' enables. More about that in the link below.
- Christopher1945Copper ContributorThanks for that - I thought that might be the only reason