Home > Drop Down > Excel Drop Down List Disappeared

Excel Drop Down List Disappeared


I read some old posts about repairing but the file is .xlsm and Excel it won't work with that extension. Why (and when) does pattern matching with f[__] perform MUCH more quickly than _f? Did I cheat? Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help. http://elliottwaveresearch.com/drop-down/excel-drop-down-list-not-working-2007.html

I version the workbook so I have screen shots where it is present and then where it's missing. Thread Tools Show Printable Version Search Thread Advanced Search January 26th, 2011 #1 afonleon View Profile View Forum Posts Member Join Date 14th December 2010 Posts 28 Drop down list Microsoft Customer Support Microsoft Community Forums TechCenter   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 Donate & thank our ninjas Chandoo.org Excel Forums - Become Awesome in Excel Home Forums > Forums > Ask an Excel Question > Home Forums Forums Quick Links Search Forums What's http://stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010

Excel Drop Down List Disappeared

I don't recall going in there and changing this but changing it back fixed it. Dim mainsrc As String Dim subsrc As String are they main source and sub source? If needs be I can put the drop downs on each individual tab but that is a lot of work and before I do that just wanted someone to confirm if

Thanks. Ozgrid is Not Associated With Microsoft. I did not find a trend in the "shifting" of the referenced cells. Excel Drop Down List Not Showing Add comment Helpful +0 Report SARC 29Posts Saturday August 7, 2010Registration date August 31, 2010 Last seen Aug 19, 2010 02:55AM wow this is awesome Rizvisa Add comment Helpful +0 Report

Thanks. Excel 2010 Drop Down List Not Working MCP, CPTS, CPTE, MCITP Server 2008, MCTS Exchange 2007 Thursday, December 12, 2013 7:48 AM Reply | Quote 0 Sign in to vote That's exactly what I mean, so i'm not read the code and the comments Reply Report SARC- Aug 23, 2010 01:28PM Hi,,.. http://www.ozgrid.com/forum/showthread.php?t=150080 It's strange because in the Data Validation the Allow setting is 'all values' (translated from dutch to eng).

So, create the following headings in a new spreadsheet: Cell A1 Student Cell B1 Subject Cell C1 Grade Cell E1 Comments We now need some data to go in our lists. Unable To View Drop Down List In Excel Can it be possible that Excel 2013 uses a new function that Excel 2007 doesn't support? But I had the List-source in another sheet. You can click on that margin to toggle break point on or off.

Excel 2010 Drop Down List Not Working

s_k_s New Member Messages: 10 This is driving me up the wall so any help would be appreciated. http://www.mrexcel.com/forum/excel-questions/404855-drop-down-list-missing-data-validation-disappears.html Register To Reply 12-14-2011,09:24 AM #10 Snarrak View Profile View Forum Posts Registered User Join Date 12-14-2011 Location The Netherlands, Maastricht MS-Off Ver Excel 2003 Posts 1 Re: Drop down list Excel Drop Down List Disappeared Excel itself will handles this part. ' This code is written with assumption that at a time only ' one cell would be changed ' if the changed column is not Excel 2013 Drop Down List Not Working Is there any way to get that back.

On the Data Tools panel, click on the Data Validation item. this content Thanks Reply Report rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus February 12, 2016 Last seen - Aug 25, 2010 06:48AM see this comment ' if the changed column is not All rights reserved. When you're finished, the Subject column should look like this: And the Grade column should look like this: In the next part, you'll see how to add an error message Drop Down List Works In Excel 2010 But Not 2007

  1. Thanks Fred!
  2. Search Free Sign Up Login Home Forum How To Download News Encyclopedia High-Tech Health Free Sign Up Language English Español Deutsch Français Italiano Português Nederlands Polski हिंदी Bahasa Indonesia Login Subscribe
  3. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 7th, 2014,09:53 AM #3 mattg29racing New Member Join Date Jan 2014 Posts 3 Re: drop down list missing

Software ▼ Security and Virus Office Software PC Gaming See More... To solve your issue, you need to know what this range this "Target" consist of Reply Report SARC- Aug 25, 2010 01:21PM ok I went into debug mode.. Have you tried intentionally telling 2010 to save your file in the 2007 format? http://elliottwaveresearch.com/drop-down/excel-2010-drop-down-list-not-working.html If you don't like Google AdSense in the posts, register or log in above.

Select Cells A1:D1 5. Excel 2007 Drop Down List From Another Sheet US Election results 2016: What went wrong with prediction models? As for the drop down list, I can't really paste the whole file as there is a lot of confidential info in there and I can't just send part of it

this value is what is the major selection.

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Linked 0 How to create drop down list in excel sheet ? Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel Excel 2007 Data Validation See if there ia validation set for the cell Register To Reply 01-26-2011,06:42 AM #6 swanseaexcel View Profile View Forum Posts Registered User Join Date 10-27-2010 Location Swansea, Wales MS-Off Ver

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 Or can this be solved. TX G See more Dropdown lists in excel 2007 Excel 2007 Dropdown list from multiple column Excel - Run macro when item is selected from dropdown list Adding a new entry check over here What is the most someone can lose the popular vote by but still win the electoral college?

the second validation list related to the first one in A2,. Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? Select all the values in col A, starting from A2 and click on name, give it name "Mill" 8. When you did in debug ?Target.Address, you saw it says $A$3 So I need to change it to If Target.address <> $A$2 Then Exit Sub But address is a string.

On a new, blank/empty workbook however, the drop down function inserts and runs normally.Does the problem reproduce itself on other computers? So if you try to put a break point on a DIM statement, nothing will show up. Overstay as a minor in USA. I had the same situation with disappearing data validation arrows, except between Excel 2010 and 2003 - my excel sheet created in 2010 didn't appear correct in 2003.

Try it out. I used a solution that I happened to already have on my laptop on an exam. Overstay as a minor in USA. Thanks!

What if I wanted this to work on just 1 cell in a column?? All rights reserved.Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback Loading Ozgrid Excel Help & Best Practices Forums

Register Help Remember Me? To print some thing, you can use either PRINT or shortcut is ? What version are you working on?

In Source box write =MyMainList 15. 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 I have saved the document as an Excel 97-2003 doc. Code ladder, Cops Why is translateY(-50%) needed to center an element which is at top: 50%?

So press F8 once so that routine starts its execution by going inside the code in intermediate window, check the target row, column and address. I'm having the same issue with data validation btwn 2007 and 2010. Is there any point in ultra-high ISO for DSLR [not film]?