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

Drop Down List In Excel 2010 Not Working In 2007

Contents

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 Jeremy share|improve this answer answered Jun 26 '14 at 14:31 Jeremy 211 Thanks!! Would it work it I added a list using 2007 and saved the file? All rights reserved.Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.4/ Connection to 0.0.0.4 weblink

Data validation ... Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 3rd, 2011 #3 rory View Profile View Forum Posts Super M‌oderator 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

Excel 2007 Drop Down List Not Visible

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.

  • 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
  • When I e-mailed it externally people using 2007 started complaining that drop downs can't be viewed.
  • All Rights ReservedAd Choices The information on Computing.Net is the opinions of its users.
  • To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum!
  • Sunday, December 08, 2013 4:35 PM Reply | Quote Moderator 0 Sign in to vote I am seeing the same thing!
  • Thanks!
  • Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Drop down list and macro work
  • 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.
  • Fixed it for me. –Flappy Feb 1 at 19:27 add a comment| up vote 0 down vote You are opening a 2007 file with 2010, saving it and closing it.

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

Excel 2010 Drop Down List Not Working

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.

I think it may be easier for you to see/experience the problem first hand.

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