Excel 2007: Data validation is on and the drop down list is no longer showing the little arrow. Data validation is still being enforced. Happened today while I was editing formulas. I version the workbook so I have screen shots where it is present and then where it's missing. I read some old posts about repairing but the file is .xlsm and Excel it won't work with that extension.
I also read some posts about copying to a new worksheet, all of the worksheets drop down arrrows have disappeared.
Panes are not frozen.
I also read some posts about copying to a new worksheet, all of the worksheets drop down arrrows have disappeared.
Panes are not frozen.