Nov 25 2022 01:44 AM
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.)
Nov 26 2022 08:28 AM
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.
Nov 26 2022 09:29 AM
Nov 27 2022 07:37 AM
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.
Apr 04 2023 09:37 PM
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.