Stock and Geography Tab Missing from Data Tab

%3CLINGO-SUB%20id%3D%22lingo-sub-2236046%22%20slang%3D%22en-US%22%3EStock%20and%20Geography%20Tab%20Missing%20from%20Data%20Tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2236046%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20be%20able%20to%20use%20the%20stock%20ticker%20price%20lookup%20feature%20in%20Excel.%26nbsp%3B%20When%20I%20select%20data%20in%20a%20table%2C%20and%20click%20on%20Data%2C%20the%20Stocks%20and%20Geography%20tabs%20are%20not%20showing.%26nbsp%3B%20How%20do%20I%20add%20these%20to%20my%20toolbar%3F%26nbsp%3B%20I%20downloaded%20the%20latest%20version%20of%20Windows%20and%20restarted%20my%20computer%20but%20it%20still%20did%20not%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2236046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2236354%22%20slang%3D%22en-US%22%3ERe%3A%20Stock%20and%20Geography%20Tab%20Missing%20from%20Data%20Tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2236354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1008898%22%20target%3D%22_blank%22%3E%40Griswold313%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWindows%20version%20practically%20doesn't%20matter%2C%20you%20shall%20have%20Office%20365%2C%20perhaps%20current%20channel%20will%20be%20safe%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I want to be able to use the stock ticker price lookup feature in Excel.  When I select data in a table, and click on Data, the Stocks and Geography tabs are not showing.  How do I add these to my toolbar?  I downloaded the latest version of Windows and restarted my computer but it still did not work.

12 Replies

@Griswold313 

Windows version practically doesn't matter, you shall have Office 365, perhaps current channel will be safe enough.

@Sergei Baklan I have Microsoft 365 and excel is in latest version. But I still can't find anything like "Data Type" or "Stock". Capture.PNG

@tayfunilbakan 

Could you please share your info as

image.png

in File->Account

@Sergei Baklan 

 

Mine is totally same as yours;

 

Capture.PNG

@tayfunilbakan 

Lack of ideas. If you are not in government or DoD environment and not on Windows 7 it shall be.

You may try to play with ribbon customization if helps

image.png

@Sergei Baklan I've managed to add data types manually as below screenshot but it seems useless. It seems like there is a drop down menu when clicking, but nothing appears.

By the way, I'm not in government or DoD environment, I'm using my personal computer with my personal account.

Capture.PNGCapture2.PNG

I have the same issue, but have not seen a resolution in below chat; any thoughts or help?

Thanks

@Griswold313 

@Griswold313 same here, doesn't work...

Same for me. The geo and stock part of the Data tab disappeared ? I can still access via office web version but not on my Mac.
Stock and Geography Tab disappeared on Excel on my Mac. I run office 365 E 3 version on mac Book Pro running Monterey 12.3.1. The tab appears on the web version (office on-line) but disappeared from the software version. My colleagues running the same subscription/version on PC do not have this issue. I did download and install office again with no luck. Thanks in advance for your help.
Also have the same issue - works on my Excel web version but not on my Mac Mini nor on my Windows machine. Is someone able to help?
I'm having the same issue!
Where did "Stocks" data type go??

I added Data Types back to the ribbon, but when I click the button, no drop-down menu appears.