The only way to recover the dropdowns that I've found so far is to copy the defective sheet to a new sheet - then the validation arrows re-appear. Why is a drop-down arrow in a data validaiton cell treated as an Excel Object in the first place – from the user's perpective – makes little sense. Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help. Click Open and Repair 5. https://community.spiceworks.com/topic/779221-drop-down-boxes-in-excel-not-working
Travis 0 Sonora OP Best Answer tcur89 Feb 6, 2015 at 11:23 UTC Just thought I would let everyone know that I found the issue is actually with Try copying the data to a new worksheet or workbook, and the data validation dropdown arrows may reappear. The video shows the most common reasons for missing arrows, and the written instructions for fixing the problems are below the video. Freeze Panes The Freeze Panes setting can cause problems with drop down arrows, in all versions of Excel.
Register Help Forgotten Your Password? What version are you working on?Just waking up and those were a few questions that popped into my head. If your dropdown is a data validation list and you have used a list on another sheet as the source, then you need to do what Tayt said, since versions pre-2010 Excel Drop Down Arrow Not Working Right-click the combo box, and click Format Control In the Input Range box, enter the name or address of the list Click OK Hidden Objects If objects are hidden on the
It was working fine until a couple of days ago. Press Enter, and enter other symbols in the cells below. TECHNOLOGY IN THIS DISCUSSION Microsoft Excel Join the Community! If you have any questions regarding the content of this notice, please contact a member of the OzGrid Administration Team If this is your first visit, be sure to check out
Travis 1 Thai Pepper OP BloodHoundGang Feb 7, 2015 at 1:05 UTC Thanks for the heads up. Drop Down List In Excel Not Working If you find the sheet to be protected, you can use this solution : http://mcgimpsey.com/excel/removepwords.html Hope it helps share|improve this answer answered Mar 27 '13 at 16:12 catalin775 1 add a That should solve the problem. In my option, The problem might be caused by the setting for Excel 2007 client site.
It's strange because in the Data Validation the Allow setting is 'all values' (translated from dutch to eng). http://sevevb.com/drop-down/drop-down-list-in-excel-not-working.html Check those instructions if you're not using Excel 2007 or later version. All rights reserved. It lists 10 names: Sugar, manufacturing, tourism etc.Is the option for autocalculate turned on? (I can't remember if that can be done on a sheet by sheet basis or the whole Excel Drop Down List Not Showing
I just copied the values in excell 2007 and saved. Is there an actual army in 1984? Computing.Net cannot verify the validity of the statements made on this site. check over here Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4.
In any version of Excel, if a drop down list is in a frozen pane of the Excel window, and the column to the right has been scrolled off screen, the Show All Objects Excel Reply Debra Dalgleish says: February 11, 2010 at 11:03 pm Thanks JP, good tip! Reply steven says: September 24, 2013 at 12:40 pm That actually worked.
Thanks Fred! Thanks. Your answer saved me a lot time Thursday, May 19, 2016 5:54 PM Reply | Quote 0 Sign in to vote Fred definitely has the answer. Excel 2013 Drop Down List Not Working In 2007 There are actually 2 different data validation settings in 2 different columns based on 2 different named ranges and neither are working.
Why is translateY(-50%) needed to center an element which is at top: 50%? i was able to fix it instantly. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. this content Please let me know the procedure to solve the same.
Why did they look stupid? How do I prevent this without using Excel 2007 for the 2007 file only and Excel 2010 for the 2010 file only? Change the column reference from 4 to match your worksheet. If you have any feedback on our support, please contact [email protected]
Click OK Video: Ignore Blank in Data Validation Blank cells can also cause problems for dependent drop down lists. The workbook is a little complex, but contains no sensitive data and I am happy to e-mail it for your assessment. To turn the alert on: Select the cell that contains a data validation list Choose Data|Validation On the Error Alert tab, add a check mark to the Show error alert after Advanced Search Forum HELP FORUMS Excel General Drop down list works in excel 2010 but not 2007?
On a new, blank/empty workbook however, the drop down function inserts and runs normally.Does the problem reproduce itself on other computers? Please mail me to dayanidhi.010[email protected] Thanks Regards Daya Monday, April 04, 2016 5:14 AM Reply | Quote 0 Sign in to vote Thank you Fred. If you want to make it easy to find the cells that have data validation lists, you can colour the cells, or add a cell comment. Later, you opened that workbook, and the data validation arrows were missing!
We apologize in advance for any inconvenience this may cause. Zoom in when specific cell is selected If cell A2 has a data validation list, the following code will change the zoom setting to 120% when that cell is selected. A few examples are shown in the list below, and you can experiment to find other symbols.