Home > Drop Down > Excel 2007 Drop Down List Not Visible

Excel 2007 Drop Down List Not Visible

Contents

All rights reserved. I'm eagerly waiting on a solution as well. Luke M, Apr 22, 2013 #2 s_k_s New Member Messages: 10 Sorry, should have mentioned that these are data validation drop downs s_k_s, Apr 22, 2013 #3 SirJB7 Excel Rōnin Messages: Why do most microwaves open from the right to the left? http://elliottwaveresearch.com/drop-down/excel-drop-down-list-not-working-2007.html

Thank you so much for the post! If I change the type of data to list I get the drop down but not the right values. Thanks. The only time I come across this problem is when 2010 excel is used.

Excel 2007 Drop Down List Not Visible

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? I read some old posts about repairing but the file is .xlsm and Excel it won't work with that extension. Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help. 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

  1. Much appreciated.
  2. Register To Reply 01-26-2011,06:02 AM #5 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
  3. On a new, blank/empty workbook however, the drop down function inserts and runs normally.Does the problem reproduce itself on other computers?
  4. What does a white over red VASI indicate?
  5. How do I prevent this without using Excel 2007 for the 2007 file only and Excel 2010 for the 2010 file only?
  6. Excel Options -> Advanced -> Display options for this workboook -> For objects, show-> All Nothing (hide objects) was checked.
  7. Or this: http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-2007-data-validation-compatibility/20a6e301-f5b7-459a-9ee4-867496342119 There're many issues regarding this problem: http://www.excelforum.com/excel-programming-vba-macros/761540-drop-down-list-and-macro-work-excel-2010-but-not-2007-a.html http://stackoverflow.com/questions/7235093/data-validation-set-in-excel-2010-fails-in-excel-2007 http://stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010 http://www.ozgrid.com/forum/showthread.php?t=150080 Regards!
  8. Is there any way to get that back.
  9. I've tried changing the macro setting in excel but this didn't work.
  10. Because they're objects too, the dropdown arrows will also be hidden.

See answer above.Oh, and your title suggests 2010, yet the tag shows 2007. Any suggestions what I can do to resolve this? So it would be easy if the lists can be filled in another sheet. Excel Drop Down List Disappeared RoyUK -------- For Excel Tips & Solutions, free examples and tutorials why not check out my web site Free DataBaseForm example Register To Reply 01-26-2011,05:59 AM #4 swanseaexcel View Profile View

However now when you are creating new sheets you are copying the entire original sheet which grabs the X1:10 so it works on those sheets.I cant really think of any reason Excel 2010 Drop Down List Not Working Register To Reply 06-16-2011,02:19 PM #9 BGbaum View Profile View Forum Posts Registered User Join Date 06-16-2011 Location Chicago, IL MS-Off Ver Excel 2010 Posts 2 Re: Drop down list and All contents Copyright 1998-2016 by MrExcel Consulting. https://social.technet.microsoft.com/Forums/office/en-US/0ca479fb-ebda-4fea-a2cf-1e9e8cd8c811/excel-2013-dropdown-menu-not-visible-in-excel-2007?forum=excel I've tested to create a file with Data Validationand andsave as Excel Workbook(xlsx) in Excel 2013 against Windows 8.

Not the answer you're looking for? Drop Down List Works In Excel 2010 But Not 2007 Thanks for your feedback and for your kind words too. Afternoon all, I've designed a spreadsheet in excel 2010 that has a dropdown list and a macro attached to a button. s_k_s, Apr 22, 2013 #5 SirJB7 Excel Rōnin Messages: 8,337 Hi, s_k_s!

Excel 2010 Drop Down List Not Working

Anybody know what why it doesn't work in Excel 2007? http://superuser.com/questions/441561/dropdownlist-works-in-excel-2010-but-not-2007 Code ladder, Robbers Should I have doubts if the organizers of a workshop ask me to sign a behavior agreement upfront? Excel 2007 Drop Down List Not Visible We apologize in advance for any inconvenience this may cause. Excel 2013 Drop Down List Not Working Jeremy share|improve this answer answered Jun 26 '14 at 14:31 Jeremy 211 Thanks!!

Friday, January 16, 2015 5:33 AM Reply | Quote 0 Sign in to vote Great. this content This issue was solved using the solution BGbaum proposed: by using names to delininate my ranges instead of defining the range using something like =$A$12:$A$13. Does the Rothschild family own most central banks? A spreadsheet in 2013 Excel, opening in 2007 and the drop down boxes are gone. Excel Drop Down Boxes Not Working

Not sure if this is the correct forum but seeing as a macro was involved I thought I'd try here first! You have defined these 10 cells A1:10 as "Some_Special_Name"In data validation you have choosen list and you entered =Some_Special_Nameright now all I can think of is the possibility that on the When using 2010 there's a drop down arrow to the right of the cell and you select an option referencing a sheet with a list of choices. weblink Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter If you've been given VBA code (a macro) for your

I have used the same spreadsheet for 2 years and it's only since windows 7 and or excel 2010 that this issue has arisen.Neil Report • Start a discussion Ask Your Unable To View Drop Down List In Excel 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. Ozgrid Retains the Rights to ALL Posts and Threads TechNet Products IT Resources Downloads Training Support Products Windows Windows Server System Center Browser   Office Office 365 Exchange Server   SQL

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

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 you have any feedback on our support, please contact [email protected] You may have to register before you can post: click the register link above to proceed. Excel Not Showing Drop Down List How the problem solved?

I found out that Data validation (including macro's) that work in 2010, don't work in 2007. Gravatar by 1e2.it I did not find a trend in the "shifting" of the referenced cells. check over here Software ▼ Security and Virus Office Software PC Gaming See More...

I originally created a workbook in 2007, got a new machine w/2010, saved the same wkbook (without touching the data validation) and now users w/2007 can't see the dropdowns!!! I tried naming my list and using source =myRangeList where myRangeList is the name of the list. How can I ensure my Playstation 2 will last a long time? I have no idea whether it is a known issue cause I cannot reproduce this behavior in my Excel 2013/2007.

I just know that depending on how you set up your data validation it can vehave differently on different sheets. Please let me know the procedure to solve the same. I have now upgraded to latest version of excel. 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

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