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

Drop Down List Excel 2010 Not Working


All of the other suggestions did not. Thanks to John Constable for this tip. Click Open and Repair 5. In this example, cells A1, B3 and D9 have data validation. http://sevevb.com/drop-down/drop-down-list-not-working-in-excel-2010.html

How does Gandalf end up on the roof of Isengard? Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. Excel Campus - Jon 25,115 views 5:46 PowerPoint - embed Excel spreadsheet into Slides - Duration: 8:02. Then I changed it to .xls format to save space.

Excel 2013 Drop Down List Not Working

I've checked all the data validation settings, and even reset them, but still the dropdown menus don't appear in any of the cells. I have NO idea how I did that but thanks to your simple explanation you made it quick, easy and painless to correct! To do this, refer to the cell with data validation in a formula on the worksheet, e.g. =MATCH(C3,CategoryList,0). Reply Debra Dalgleish says: January 7, 2015 at 4:33 pm You're welcome!

To see an example, go to the Sample Worksheets page, and under the Filters heading, find Product List by Category, and download the ProductsList97Calc.zip file. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not Toggle navigation Contextures Tips Files Products Blog Search Data Validation Tips and Quirks Tips for solving problems with drop down lists, and workarounds for data validation limitations, such as small font, Drop Down List Stopped Working Excel Try copying the data to a new worksheet or workbook, and the dropdown arrows may reappear.

Transcript The interactive transcript could not be loaded. Excel Drop Down List Not Working 2007 Zoom in when specific cells are selected If several cells have a data validation list, the following code will change the zoom setting to 120% when any of those cells are You may have to register before you can post: click the register link above to proceed. Reply Karen says: May 15, 2013 at 5:14 pm You just restored my sanity!

Watch QueueQueueWatch QueueQueue Remove allDisconnect Loading... Excel Drop Down Arrow Not Working Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. Add Cancel × Insert code Language Apache AppleScript Awk BASH Batchfile C C++ C# CSS ERB HTML Java JavaScript Lua ObjectiveC PHP Perl Text Powershell Python R Ruby Sass Scala SQL Would the members of an online imageboard (or any community) be able to build a post-apocalytic society upon their reputation?

Excel Drop Down List Not Working 2007

Reply Murat says: July 22, 2014 at 3:57 am My file was first created as .xlsm and contained VBA codes. http://www.excelforum.com/showthread.php?t=826137 Thanks again Reply Alexey Fedorov says: May 10, 2013 at 12:48 pm Activate objects was the solution for me. Excel 2013 Drop Down List Not Working Encasing a star in a perfect insulator TSA broke a lock for which they have a master key. Excel 2007 Drop Down List Not Visible I have now upgraded to latest version of excel.

There are instructions here. http://sevevb.com/drop-down/drop-down-list-in-excel-not-working.html Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim lZoom As Long Dim lZoomDV As Long Dim lDVType As Long lZoom = 100 lZoomDV = 120 lDVType = 0 Application.EnableEvents = False On Software ▼ Security and Virus Office Software PC Gaming See More... more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Excel Drop Down List Not Showing

  1. The time now is 08:16 AM.
  2. I think it may be easier for you to see/experience the problem first hand.
  3. Report • #5 Djwaunnie July 26, 2011 at 07:39:38 Dear Kitty,How do I go about sending you the file privately?
  4. Change the column reference from 4 to match your worksheet.
  5. It worked fine form me Thanks!
  6. If you type "No", the entry will be accepted, without an error message, because the first letter is upper case, and the second letter is lower case.
  7. Ozgrid is Not Associated With Microsoft.
  8. Creating your account only takes a few minutes.

Results 1 to 5 of 5 Thread: Drop down list works in excel 2010 but not 2007? The person who set up the list left a few blank cells at the end, where new items could be added. The name Bill is not in the list, but was allowed in the cell. http://sevevb.com/drop-down/drop-down-list-in-excel-2010-not-working.html We flip files between different linguistic versions of excel, but again, we have done this for years.

To create a combo box: Click the Developer tab on the ribbon, and click Insert Click the Combo Box in the Form Controls On the worksheet, drag to add a combo Excel 2013 Drop Down List Not Working In 2007 I originally made the spreadsheet in an older version of excel. On a new, blank/empty workbook however, the drop down function inserts and runs normally.Does the problem reproduce itself on other computers?

Here is a link to the page Data Validation Font Size and List Length The font size in a data validation list can't be changed, nor can its default list length,

As a workaround, follow these steps to make the arrow appear: Select the cell with the data validation list Click outside of the Excel window (e.g. The issue occurs when the Excel 2010 document that contains list type data validation and the values for the lists reside on OTHER worksheets. Bill Jelen 8,836 views 7:55 Learn Excel - Running Total in Footer - Podcast 2058 - Duration: 10:04. Show All Objects Excel However, if a different name is typed in that column, there is no error alert.

then arrows disappeared. Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and 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 this content Activate objects kept resetting itself to HIDE.

this is the only site that gave full details and options of how to fix this issue. http://answers.microsoft.com/en-us/office/forum/office_2010-excel/kb2553154-breaks-com-and-active-x-... However, if created in a new worksheet, drop down lists insert and function normally.I think my worksheet is currupt or I've done something to the worksheet/workbook that Excel is clearly very Sign in to report inappropriate content.