Home > Drop Down > Drop Down List In Excel 2010 Not Working

Drop Down List In Excel 2010 Not Working

Contents

Yes No I don't know View Results Poll Finishes In 6 Days.Discuss in The LoungePoll History About Us | Advertising Info | Privacy Policy | Terms Of Use and Sale | This occurs when a named range is used as the list source, and there is a blank cell anywhere in that named range. or at all..   7 Replies Tabasco OP 007theit Feb 6, 2015 at 9:58 UTC Installation probably got corrupted on his machine some how since it works for I have NO idea how I did that but thanks to your simple explanation you made it quick, easy and painless to correct! http://sevevb.com/drop-down/drop-down-list-not-working-in-excel-2010.html

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

Excel 2013 Drop Down List 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.

  1. Privacy statement  © 2016 Microsoft.
  2. All of the other suggestions did not.
  3. To turn it back on: Select the cell that contains a data validation list On the Ribbon, click the Data tab Click the top of the Data Validation button, to open
  4. Or, try to repair the Excel file as you open it: 1.
  5. There were additional problems in Excel 97 and earlier.
  6. I'm eagerly waiting on a solution as well.
  7. Code ladder, Robbers Is RandomGraph really random?
  8. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Range("A1,B3,D9")) Is Nothing Then ActiveWindow.Zoom = 100 Else ActiveWindow.Zoom = 120 End If End Sub Zoom
  9. So, you might have 100 cells with data validation drop down lists, but you'll only see the arrow in the active cell.
  10. Text Quote Post |Replace Attachment Add link Text to display: Where should this link go?

Excel Drop Down List Not Working 2007

MCP, CPTS, CPTE, MCITP Server 2008, MCTS Exchange 2007 Edited by Martin van der Voort Monday, December 02, 2013 7:54 AM Monday, December 02, 2013 7:50 AM Reply | Quote 0 http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/excel-2010-drop-down-disappears-when-file-is/3dcc4f16-3231-4a4b-8492-4f0be3150e4d By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks. Excel 2013 Drop Down List Not Working Create a Default Item at Top of List Or, make " --Select--" the top item in the Product list, and set up the worksheet with " --Select--" entered in each product Excel 2007 Drop Down List Not Visible It took some debugging in VBA to see that the arrows have names of the form "Drop Down N", where N = 1, 2, 3, ….

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.

Your browser can't show this frame.

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.