Data validation ... Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 3rd, 2011 #3 rory View Profile View Forum Posts Super Moderator Join Date 2nd May 2008 Location Ubique Posts 2,266 I needed to provide two versions of the same spreadsheet: one saved as Excel 2007 file, and the other one as Excel 2010 file. Tell us how did you go on and welcome back whenever needed or wanted. http://stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010
Your cache administrator is webmaster. I did not find a trend in the "shifting" of the referenced cells. Is there any way to get that back.
Computing.Net cannot verify the validity of the statements made on this site. 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)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 try setting it up in 2007 first Register To Reply 06-16-2011,02:09 PM #8 BGbaum View Profile View Forum Posts Registered User Join Date 06-16-2011 Location Chicago, IL MS-Off Ver Excel 2010 Excel Drop Down List Disappeared Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help.
I originally made the spreadsheet in an older version of excel. Excel 2010 Drop Down List Not Working Thread / Post Bookmarking by Thread / Post Bookmarking v1.1.0 - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd. Ozgrid is Not Associated With Microsoft. 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 Eval.
Gravatar by 1e2.it Drop Down List Works In Excel 2010 But Not 2007 To start viewing messages, select the forum that you want to visit from the selection below. Kind regards, Martin van der Voort. 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
Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. http://superuser.com/questions/441561/dropdownlist-works-in-excel-2010-but-not-2007 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 Excel 2007 Drop Down List Not Visible Afternoon all, I've designed a spreadsheet in excel 2010 that has a dropdown list and a macro attached to a button. Excel 2013 Drop Down List Not Working excel share|improve this question edited Oct 10 '11 at 20:08 PowerUser 7,021104579 asked Oct 10 '11 at 16:14 user988003 16112 add a comment| 4 Answers 4 active oldest votes up vote
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. have a peek at these guys Excel Training / Excel Dashboards Reports IMPORTANT INFORMATION The OzGrid Free Excel & VBA Help Forum will beupgrading to the new vBulletin 5 Connect software over the next few working days, If I open the Excel 2007 file with Excel 2010, in the cells where I inserted the drop down list, the reference to the cells that contain the list is somehow This functionality didn't exist in Excel 2003 but it is in 2007. Excel Drop Down Boxes Not Working
Thanks. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there The workbook is a little complex, but contains no sensitive data and I am happy to e-mail it for your assessment. http://sevevb.com/drop-down/drop-down-list-not-working-in-excel-2010.html 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
If you don't like Google AdSense in the posts, register or log in above. Unable To View Drop Down List In Excel The 6 data sheets of the workbook were created in Microsoft Excel 2010, (part of my Office Professional Suite).Does the problem reproduce itself on other versions? Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please contact [email protected] 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 Privacy statement © 2016 Microsoft. Excel Not Showing Drop Down List Panes are not frozen.
Term for a perfect specimen or sample Giving change in smaller denominations so customers can tip? Yours, Chandoo Hi All Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam Post Spam and you Will Be Deleted as a User Hui... How do I prevent this without using Excel 2007 for the 2007 file only and Excel 2010 for the 2010 file only? http://sevevb.com/drop-down/drop-down-list-in-excel-2010-not-working.html MCP, CPTS, CPTE, MCITP Server 2008, MCTS Exchange 2007 Edited by Martin van der Voort Monday, December 02, 2013 7:54 AM Monday, December 02, 2013 7:50 AM Reply | Quote 0
Yes, my password is: Forgot your password? Why do most microwaves open from the right to the left? I'm having the same issue with data validation btwn 2007 and 2010. 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
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