Excel new Data Types not showing

Question

Hi All,

Hopefully, I will get some help. After numerous attempts at contacting Office 365 pro team, raising help desk etc... I still did not get any answer to my problem and keep on being redirected to other services who act like they're playing hot potato game with me.

I have an Office 365 Proplus license. I'm on the monthly targeted channel. I updated to the latest version, made sure I was logged in on my pro account.

My version is 1812 (Build 11126.20132). 

I got a notification from Microsoft saying the new data types should be available on my version. However it's nowhere to be found. (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32223604-pull-current-stock-prices-and-historical-data-into?tracking\_code=8f4c542ff27c213575a6b3d8f949d5e2)

A few months ago, I logged in from a different country and could use the feature, the moment I got back to Hong Kong it was gone again.

Any idea or contact I can reach out to? This is getting exhausting and I am really disappointed with that level of service considering I'm paying premium price for it.

Answer 1

Hi Steven

From your description, it seems that you can’t see the Stock and Geography options under Data in your Excel 2016 application. If yes, I first suggest you navigate to Control Panel>Programs>right-click on the Office 2016 applications’ icon>Change>Repair and then restart the computer to see and let us know the result.

 

Meanwhile, check if the issue happens in a specific file and if you are using the English version of the Office 2016 applications.

Thanks,

Cliff

Answer 2

Hi Cliff,

I have that, nothing is showing still. I'm using English version (US) of Office 365 Proplus (not 2016). I was able to use it in May 2018 but right after an update it just disappeared.

Answer 3

Same Issue Here. Version 1811 (Build 11029.20108 Click-to-Run).

Answer 4

Found an answer from this thread:

https://answers.microsoft.com/en-us/msoffice/forum/all/stock-and-geography-data-types-missing-from-data/79c00ad2-9ecc-4bd9-b46d-6e1fefe76426

You need to login to your Office Account for the Data Types to show.

Answer 5

Hi Steven,

There seems to be a new update for the version of the Office 2016 applications. I suggest you first update the version to the latest version, restart the computer and then do a test to see and let us know the result.

@Jason, thanks for sharing the information here. If the issue persists in your environment, I suggest you post a new thread on our forum for expert help.

Thanks,

Cliff