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

Drop Down List Not Working In Excel 2007


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, So that is your error I can give you the answer, but I have a feeling that you are trying to learn as you go. I am using Excel 2010 installed on Windows 7.Regards,Djwaunnie Report • Related Solutions› [Solved] How to create drop down list in Excel? › Why wo't drop down lists won't work in one more thing pls... weblink

it was because I had entered values in other cells in the same row as the validation... one more issue though,.. Not sure if this is the correct forum but seeing as a macro was involved I thought I'd try here first! and thanks for your patients... http://stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010

Excel Drop Down List Disappeared

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: Report • #5 Djwaunnie July 26, 2011 at 07:39:38 Dear Kitty,How do I go about sending you the file privately? MS should fix this compatability bug ASAP!!!

Thanks. Do I have to rebuild it? Blueprint a sestina Isn't the BBC being extremely irresponsible in describing how to authenticate an account-related email? Excel Drop Down List Not Showing Here is the FAQ for this forum. + Reply to Thread Results 1 to 11 of 11 Drop down list and macro work excel 2010 but not 2007?

Private Sub Worksheet_Change(ByVal Target As Range) 'Target is the cell or a range of cells whose values were changed ' and that triggered the change. Excel 2010 Drop Down List Not Working Thanks Fred! 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 If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate?

How do I prevent this without using Excel 2007 for the 2007 file only and Excel 2010 for the 2010 file only? Unable To View Drop Down List In Excel current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Here's a picture of your finished spreadsheet: In the image above, we can simply select a student from the drop down list - no more typing! If this is your original dropdown box formula: =Sheet2!A1:A5 Then change it to: =INDIRECT("Sheet2!A1:A5") For me, this stops it removing the dropdown when opening in Excel 2007 after saving in Excel

Excel 2010 Drop Down List Not Working

If I change the type of data to list I get the drop down but not the right values. http://www.mrexcel.com/forum/excel-questions/404855-drop-down-list-missing-data-validation-disappears.html All rights reserved. Excel Drop Down List Disappeared So this might be a solution for the questions above! Excel 2013 Drop Down List Not Working A spreadsheet in 2013 Excel, opening in 2007 and the drop down boxes are gone.

Thanks. have a peek at these guys Wednesday, December 04, 2013 2:17 AM Reply | Quote Moderator 0 Sign in to vote Hello Tony, Thank you for your response. Overstay as a minor in USA. you would see a brown dot too on the left margin. Drop Down List Works In Excel 2010 But Not 2007

Exercise Add drop down list to the B and C columns. but how can I upload a file? Does anybody have an idea? check over here Linked 0 How to create drop down list in excel sheet ?

Browse other questions tagged microsoft-excel microsoft-excel-2010 or ask your own question. Excel 2007 Drop Down List From Another Sheet I've tested to create a file with Data Validationand andsave as Excel Workbook(xlsx) in Excel 2013 against Windows 8. Again, it works in excel 2010, but not in excel 2007.

Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help.

  1. Thanks.
  2. Reply Report rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus February 12, 2016 Last seen - Aug 25, 2010 04:47PM No problem, as long as you are trying to learn, no
  3. 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
  4. When I put everything in Excel 2010 in one sheet, it also works on Excel 2007.
  5. Anybody know what why it doesn't work in Excel 2007?
  6. Register To Reply 01-26-2011,06:49 AM #7 royUK View Profile View Forum Posts Visit Homepage Forum Expert Join Date 11-18-2003 Location Derbyshire,UK MS-Off Ver Xp; 2007; 2010 Posts 26,205 Re: Drop down
  7. Kind regards, Martin van der Voort.
  8. GO OUT AND VOTE How can I ensure my Playstation 2 will last a long time?
  9. The workbook is a little complex, but contains no sensitive data and I am happy to e-mail it for your assessment.
  10. Jeremy share|improve this answer answered Jun 26 '14 at 14:31 Jeremy 211 Thanks!!

Also you should start Intermediate Window. Share it with others Like this thread? Thanks. Excel 2007 Data Validation From the Data tab, locate the Data Tools panel.

Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help. Ozgrid Retains the Rights to ALL Posts and Threads current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. I have now upgraded to latest version of excel. this content In Excel, this comes under the heading of Data Validation.

It works fine on my PC but when I email the spreadsheet to anyone, regardless of the version of excel, the drop down lists dont work anymore. But you have done here just like that! ;-) Many Thanks rizvisa Reply Report Thirilog- Nov 23, 2010 09:03AM is there any chance to make the above scenario without macro? How?