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

New 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.)

2 Replies


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.