Generated Sun, 13 Nov 2016 12:12:59 GMT by s_wx1194 (squid/3.5.20) current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. I'm having the same issue with data validation btwn 2007 and 2010. It will be enabled later on. There were some other shapes on the worksheet, like logos, or text boxes, and we changed a setting to hide them. weblink
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 Please Login or Register to view this content. 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 Hope to see more info. http://stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010
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, I just copied the values in excell 2007 and saved. The time now is 08:16 AM. 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
If you name the ranges of the lists you are using and then use those names when sourcing the lists for the cells. Thanks. We are here to make you awesome in Excel. Excel Not Showing Drop Down List 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..
Reply Report rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus February 12, 2016 Last seen - Aug 25, 2010 01:33PM So you got it resolved right ? Excel 2013 Drop Down List Not Working Double click on "sheet1" in the project explorer 18. Once again target represents a RANGE that was changed. 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 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 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. Drop Down List Works In Excel 2010 But Not 2007 Now click on Column A to highlight that entire column: With Column A highlighted, click on Data from the Excel Ribbon at the top. the values wont appear in cellB2,. Why is "Try Again" translated to やり直す?
Reply Report goms- Jan 8, 2011 04:54AM This is really helpful. Have you tried to repair the source file as I mentioned in my last reply? Excel 2010 Drop Down List Not Working Have you tried intentionally telling 2010 to save your file in the 2007 format? Excel Drop Down Boxes Not Working So, type the same data as in the image below.
It doesn't need to go in the same columns as ours. have a peek at these guys But I had the List-source in another sheet. Why Would the President-elect have a Transition Visit before December 19? You can either just type in your cell references here, or let Excel do it for you. Excel Drop Down List Disappeared
Thanks for your feedback and for your kind words too. Baramm. It's freezing up over the xlPivottable14 part - I'm presuming this is not compatible with Excel 2007 but I'm not sure how to get around it. http://sevevb.com/drop-down/drop-down-list-not-working-in-excel-2007.html Sunday, December 08, 2013 4:35 PM Reply | Quote Moderator 0 Sign in to vote I am seeing the same thing!
Is the untested/empty statement true? Unable To View Drop Down List In Excel but the validation list appears and I can select the values but the values wont show up in the cell...?? One of the reasons I have come to understand is that freeze panes and drop downs don't get on with each other, so fine I got rid of freeze panes but
How do I do that? Put the values of Mill, Comp, Loads and Blending under its respective column heading (make sure no blank line) 3. Click on define Name 6. Excel 2007 Drop Down List From Another Sheet Fred Proposed as answer by Marc43016 Wednesday, June 08, 2016 4:00 PM Friday, March 14, 2014 10:49 AM Reply | Quote 0 Sign in to vote PROBLEM SOLVED.
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 Thursday, January 08, 2015 3:59 PM Reply | Quote 0 Sign in to vote perfect this works. 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 this content Go to Data tab on menu and click on Data Validation 13.
We apologize in advance for any inconvenience this may cause. Only we are using it to capture the current validation formula in cell B They are not the main or sub source. Blueprint a sestina How can I ensure my Playstation 2 will last a long time? 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
Thanks. the comments really helped me understand the programme.. Register Help Forgotten Your Password? Works fine in 2010 which is used internally.
Perhaps 2010 is automatically converting your file to the 2010 format. Please let us know if you would like further assistance. MS should fix this compatability bug ASAP!!! you would see a brown dot too on the left margin.
From the Data tab, locate the Data Tools panel. The validation just dissapeared from the cells... Thanks! Browse other questions tagged microsoft-excel microsoft-excel-2010 or ask your own question.
In Excel, this comes under the heading of Data Validation. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... and to find out what to edit so I dont get an error when change something in column A... Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help.
The excel I created in Windows 2013, I have all the lists, but when opened in 2007, all the cells are defaulted back to "Any Value" and can't see the in-cell