AA, BB, CC & DD. This may help http://www.contextures.com/xlDataVal...rowsNotVisible Share Share this post on Digg Del.icio.us Technorati Twitter HTH, Peter Please test any code on a copy of your workbook. If you have any feedback on our support, please contact [email protected] Essentially, from my understanding, the data validation (which I assume is the dropdown menu) looks at a list of initials within a range (which are still there) elsewhere on the sheet. http://sevevb.com/drop-down/drop-down-list-in-excel-not-working.html
Thank you again. Which is a valid named range when I look it up. Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help. He also says that the right click only works on the two drop downs next to the first one.
Missing Arrows Occasionally, data validation dropdown arrows are not visible on the worksheet, in cells where you know that data validation lists have been created. However, if a different name is typed in that column, there is no error alert. To download the sample file, click here: Remove Blanks With Dynamic Range Sample File Why does this happen, and how can you prevent it? 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
To make the objects visible again, follow these steps: Click the Office Button, then click Excel Options.Click the Advanced CategoryScroll down to the 'Display Options for This Workbook' sectionUnder 'For Objects, it helped me to resolve my problem thanks Monday, April 20, 2015 10:08 AM Reply | Quote 0 Sign in to vote Hi, I am struggling with a similiar issue. Where to Learn Excel & Advice Megathread Submission Guidelines and Sharing Questions Frequently Used Formulas Awarding ClippyPoints Thread flair: unsolved/solved Common VBA Mistakes /r/excel Guides and Write-ups /r/excel Wiki MICROSOFT COLLABORATION Excel 2007 Drop Down List Not Visible Is the drop down arrow you click on a grey box with a black arrow? (Like typical windows styling).
Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search The drop down list does not appear. Is it possible to get the activation arrow positioned on the left? As an example: Does NOT work with 2007: Data Validation --> Allow: List --> Source: ='WorksheetName'!$A$1:$A$10 Works with 2007: Data Validation --> Allow: List --> Source: =NamedRange where NamedRange ='WorksheetName'!$A$1:$A$10 Wednesday,
The following are the most common reasons for this. Excel Drop Down Arrow Not Working To address the problem, you could use a combo box or listbox, or temporarily increase the zoom setting. share|improve this answer answered Oct 27 '14 at 20:40 vembutech 4,4721612 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Friday, January 16, 2015 5:33 AM Reply | Quote 0 Sign in to vote Great.
I have run into a problem that I cannot correct. http://www.contextures.com/xlDataVal08.html It doesn't matter if the cell is selected or not. Excel Drop Down List Not Working 2007 Note: To see all the graphic characters, go to the Code Page 437 entry in Wikipedia. Excel 2010 Drop Down List Not Working Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help.
E-mail: Advertisements Drop Down Menu Does Not Work. have a peek at these guys If I try to type a value not defined where the list is located I get an error message telling me I am attempting to add a value not in the Friday, November 29, 2013 4:37 PM Reply | Quote Moderator 0 Sign in to vote Hi, Just checking in to see if the information was helpful. All rights reserved. Excel Drop Down List Not Showing
I would like the arrow to be visible at all times. I tried a search but just wasn't getting the right answers. Thanks to John Constable for this tip. check over here OP - please reply to the answer with: Solution Verified This will change the flair to SOLVED and award the user a ClippyPoint TO APPLY CODE FORMATTING Use 4 spaces to
What version are you working on? Show All Objects Excel Remember Me? Any ideas?
Your email address will never be shared with anyone else. I can't seem to find any option for this in the Data Validation dialog. 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 Drop Down List Not Working On Some Computers Any ideas?
How can I claim compensation? MCP, CPTS, CPTE, MCITP Server 2008, MCTS Exchange 2007 Thursday, December 12, 2013 7:48 AM Reply | Quote 0 Sign in to vote OK. 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 this content 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
My cat sat on my laptop, now the right side of my keyboard types the wrong characters Why is looping over find's output bad practice? Please mail me to [email protected] Thanks Regards Daya Monday, April 04, 2016 5:14 AM Reply | Quote 0 Sign in to vote Thank you Fred. Is there some error with older versions of Excel? 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.
permalinkembedsavegive gold[–]jayacher[S] 0 points1 point2 points 1 year ago(0 children)Hi, thanks for your response. Macro to Temporarily Change Zoom Setting To make the text appear larger, you can use an event procedure (three examples are shown below) to increase the zoom setting when the cell I think Martin is saying that 2007 does no have the list, but when he re-links to the correct source for the lsit, then it works. Results 1 to 3 of 3 Why have my data validation dropdown boxes have stopped working?This is a discussion on Why have my data validation dropdown boxes have stopped working?
Join the community Back I agree Powerful tools you need, all for free. PS. Looking forward to hearing you. Off-Topic Tags How-tos Drivers Ask a Question Computing.NetForumsOffice SoftwareMicrosoft Office Drop Down Listed in Excel '10 stopped working Tags:Microsoft Microsoft excel 2007 full vers...excelcommunity Djwaunnie July 25, 2011 at 21:51:55 Specs: