Dear Specialists,

I use excel worksheet in my office to submit finance claim.

The sheet uses dropdown list(or, maybe combobox) and it worked normally until around last December.

Every month, I use it by copying the last month's sheet. But since December 2014 or November 2014, dropdown list in the sheet suddenly became not working. Please see the attached picture. 

When I try to click the list, list don't appear and combobox icon is selected as if it is normal picture. I could also change the icon size like normal picture.

https://social.technet.microsoft.com/Forums/getfile/621698

I checked similar article in this forum and checked "advanced option - show all object", "activeX enable" and so on, but couldn't find solution.

The strange fact I wonder is;

- After this problem found on the file after last December, the old files before last December which could show dropdown list normally were also changed into not showing the list.

- Another colleague who is using same PC as me is also experiencing same problem.

- Data Validation menu of this file is not able to be changed because this file is protected.

- Another dropdown list in the same worksheet is still working normally(please see the next picture). 

https://social.technet.microsoft.com/Forums/getfile/621704

According to these facts, I believe this is not problem of setting of Excel but maybe related to OS update or security soft update.

We are using ESET smart security since 3 years ago.

Does anyone have same problem and found solution?

Best Regards,

Iwao

• Edited by IwaoHashiba 4 hours 1 minutes ago typo