Join them; it only takes a minute: Sign up drop down list compatibility issue between Excel 2007 and Excel 2010 up vote 3 down vote favorite 1 I prepared a spreadsheet Hidden objects was my problem. 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 What is the meaning of "cow in the middle"? weblink
Thanks Travis Tags: Microsoft ExcelReview it: (38) Reply Subscribe View Best Answer RELATED TOPICS: SQL Server 2008 R2 Standard Excel - pull multiple values with dropdown list excel macros not working Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help. Thanks for any help. Any ideas? https://community.spiceworks.com/topic/779221-drop-down-boxes-in-excel-not-working
Reply Debra Dalgleish says: February 11, 2010 at 11:03 pm Thanks JP, good tip! During this upgrade there may be some intermittent down time preventing access to the forum or certain features. Computing.Net and Purch hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy. Drop Down List In Excel Not Working Uygunsuz içeriği bildirmek için oturum açın.
Remember his wont do that. Thanks, Travis Screenshot.docx (60.2 KB) 0 Sonora OP tcur89 Feb 6, 2015 at 10:32 UTC Repairing Microsoft Office had no effect. Excel 2013 Drop Down List Not Working I had the same problem and calling the lists out as ranges on the other worksheet tab fixed the problem. Baramm. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/excel-2010-drop-down-disappears-when-file-is/3dcc4f16-3231-4a4b-8492-4f0be3150e4d That should solve the problem.
If you want to make it easy to find the cells that have data validation lists, you can colour the cells, or add a cell comment. Excel 2013 Drop Down List Not Working In 2007 Text Quote Post |Replace Attachment Add link Text to display: Where should this link go? If you want drop down arrows that are always visible, you can use combo boxes instead of data validation. ExcelIsFun 46.018 görüntüleme 24:25 Data Validation 6 - Run Macros from Drop Down Menus in Excel - Süre: 9:12.
Reply Jimbo says: March 31, 2015 at 3:07 pm I guess from everyone's thanks, this seems to happen, although it's the first time I've ever encountered it. http://sevevb.com/drop-down/drop-down-list-in-excel-not-working.html Reply MOHAMMED TAWFIQ MASSAED says: July 9, 2014 at 12:37 am Thank you very much .. Reply Bear says: June 24, 2013 at 9:04 am (Excel 2010) The arrow may disappear if there is a freeze pane on the column with the data validation, and you scroll Reply Zaka Ur Rehman Khan says: December 28, 2015 at 10:48 am It worked, thanks dear. Excel Drop Down List Not Showing
All Rights ReservedAd Choices The information on Computing.Net is the opinions of its users. Report • #5 Djwaunnie July 26, 2011 at 07:39:38 Dear Kitty,How do I go about sending you the file privately? Bu videoyu bir oynatma listesine eklemek için oturum açın. http://sevevb.com/drop-down/drop-down-list-in-excel-2010-not-working.html I knew it had to do with hidden objects after my hour search online but nowhere did it say where the fix is.
To make the objects visible again, follow these steps: Click the Office Button, then click Excel Options.Click the Advanced CategoryScroll down to the 'Display Options for This Workbook' sectionUnder 'For Objects, Excel Drop Down Arrow Not Working Your answer saved me a lot time Thursday, May 19, 2016 5:54 PM Reply | Quote 0 Sign in to vote Fred definitely has the answer. Try copying the data to a new worksheet or workbook, and the data validation dropdown arrows may reappear.
Can it be possible that Excel 2013 uses a new function that Excel 2007 doesn't support? That will probably take care of it. 0 Mace OP Sosipater Feb 6, 2015 at 10:03 UTC What kind of dropdowns are we talking about? Reply With Quote Feb 28th, 2011,07:07 AM #3 Kelvin Stott Board Regular Join Date Oct 2010 Posts 263 Re: Why have my data validation dropdown boxes have stopped working? Show All Objects Excel To turn it back on: Select the cell that contains a data validation list On the Ribbon, click the Data tab In the Data Tools group, click Data Validation On the
If you have any feedback on our support, please contact [email protected] I also did a side by side comparison of our settings and they are identical. Any ideas? I got this issue in excell 2013. Required fields are marked *Comment Name * Email * Website Oct 1, 2106: I've installed a new theme for the blog, so if you see anything wonky, please let me
Yükleniyor... Çalışıyor... Drop Down Arrows In Excel 2003 and Earlier There are instructions on the Contextures website for fixing missing data validation arrows in Excel 2003 and earlier versions. Perhaps 2010 is automatically converting your file to the 2010 format. According to a Microsoft forum, this can be resolved by downloading the MS Office Compatibility pack at: http://www.microsoft.com/en-us/downl...ails.aspx?id=3 Excel Video Tutorials / Excel Dashboards Reports Reply With Quote Quick Navigation Excel