Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Why does Excel 365 have two "Stocks" data type buttons?

Copper Contributor

In my Excel 365, Data | Data Types has two "Stocks" buttons.  As far as I can tell, they are both cosmetically and functionally identical.  Is there any good reason for both buttons, or is this just a bug that needs fixing?

 

(Windows 10, if that matters.)

4 Replies

@Microsoft_Store 

Most probably that's a bug which appears in your concrete environment. In consumer version we have bot Currencies and Stocks icons which are working exactly the same way but have different interface. Perhaps in your case you have both but with the same name.

I would have assumed a bug except that it's so glaringly obvious. The two buttons really do seem identical -- same cosmetics, same tooltip, and each button converts tickers to stock data types. As to Currencies, there is also a Currencies button next to the two Stocks buttons. There really does seem to be an extra, duplicative, Stocks button. As far as I can tell, it is harmless, so I'll just ignore it unless some tangible problem crops up. Very vanilla environment: Windows 10 with up-to-date patches, brand new original download of Office 365. Nothing unusual about my environment that I am aware of.

@Microsoft_Store 

You may to Repair office (data will be kept) or full repair as here Repair an Office application - Microsoft Support , but in this case data in profile will be cleaned.

I'd stop on online Repair, nothing serious.

As a comment, Windows version practically doesn't matter if that's any after Win7. Office 365 - here it's important your subscription and on which channel you are.

 

 

 

@Sergei Baklan 

 

Seems like the first Icon is a "recently used" icon and therefore 2 are shown since the Stocks Icon is the first in the list. Just click on the down arrow on the right side of the Data Types dropdown and you will see many Icons.

 

I assume that as you use the other Icons they will appear first as recently used Icons.

 

Not a bug ... just bad UI! Look at how much time we wasted here.