SOLVED

Excel Data Types is not enabled

Copper Contributor

I have installed Office 365 version 1909 installed in Portuguese Language. I'm looking for the feature of Stocks as part of Data Types, but that is not enabled in my Excel.

 

I have the last version of excel and office. I also removed the office and installed again, but the feature is still not enabled in my personal computer.

 

I need help to resolve this issue and make the usage of Stocks updates in my personal Excel.

 

Just for reference:

In my work, I use a desktop with Windows and Office 365 with Excel. Currently the version 1902 is installed and updates are controlled by the company and that is installed in English. The Stocks from Data Types are available correctly there.

5 Replies
best response confirmed by JoseAntonio_ (Copper Contributor)
Solution
It seems that you can add English as a language and that will allow it to appear. See the bottom FAQ on this page: https://support.office.com/en-us/article/excel-data-types-stocks-and-geography-61a33056-9935-484f-8a....

Hi @Tim_Heng 

 

Unfortunatelly that does not work. I still dont have the stocks feature enabled in my Excel.

 

Thanks,

One possibility - I seem to recall that the Stocks feature will not be shown when you are not connected to the internet. Is your computer internet-enabled?

@Tim_Heng 

 

Hi Tim, thanks for your message.

 

Yes, my computer is connected to the internet. I also have another notebook in which I use the same MS Office installed and the Stock feature is enabled there and working properly. It is same version of Office and Excel.

 

Att.

Jose.

Hi @Tim_Heng 

 

Yes, you are right. I received support from Microsoft. They removed my office manually and completelly including registers and etc. After that, Excel was brand new, but without Data Types enabled. Then, they installed English language in my office and Data Types was launched. Now it is all right.

 

Thanks for your inputs.

1 best response

Accepted Solutions
best response confirmed by JoseAntonio_ (Copper Contributor)
Solution
It seems that you can add English as a language and that will allow it to appear. See the bottom FAQ on this page: https://support.office.com/en-us/article/excel-data-types-stocks-and-geography-61a33056-9935-484f-8a....

View solution in original post