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

Drop Down List Not Working In Excel 2010

Contents

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

Excel Drop Down List Not Working 2007

Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help. more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science See answer above.Oh, and your title suggests 2010, yet the tag shows 2007. MCP, CPTS, CPTE, MCITP Server 2008, MCTS Exchange 2007 Thursday, December 12, 2013 7:48 AM Reply | Quote 0 Sign in to vote OK.

  • 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
  • Operating Systems ▼ Windows 10 Windows 8 Windows 7 Windows XP See More...
  • videoturo 35.942 görüntüleme 3:00 Create drop-down menus in Excel - Süre: 5:55.
  • Home Drop down boxes in Excel not working by tcur89 on Feb 6, 2015 at 9:56 UTC | Microsoft Office 0Spice Down Next: Outlook 2013 issue, when replying to an e-mail
  • Ozgrid is Not Associated With Microsoft.
  • Thanks.
  • Is there any way to get that back.
  • Cheers, Tony Chen Forum Support ________________________________________ Come back and mark the replies as answers if they help and unmark them if they provide no help.
  • Who would have thought to freeze the pane next to the data validations would work.

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.

Excel 2013 Drop Down List Not Working

Why were pre-election polls and forecast models so wrong about Donald Trump? http://www.mrexcel.com/forum/excel-questions/532351-why-have-my-data-validation-dropdown-boxes-have-stopped-working.html Yes No I don't know View Results Poll Finishes In 6 Days.Discuss in The LoungePoll History About Us | Advertising Info | Privacy Policy | Terms Of Use and Sale | Excel Drop Down List Not Working 2007 When the creator send a screen shot, she has text, when I open it after trying the setting for objects=all and doing the Open and repair, I still see the data Excel 2007 Drop Down List Not Visible I can now sleep easy at night.

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.

Results 1 to 3 of 3 Why have my data validation dropdown boxes have stopped working?This is a discussion on Why have my data validation dropdown boxes have stopped working?

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

Add Cancel × Insert code Language Apache AppleScript Awk BASH Batchfile C C++ C# CSS ERB HTML Java JavaScript Lua ObjectiveC PHP Perl Text Powershell Python R Ruby Sass Scala SQL Not the answer you're looking for? I just copied the values in excell 2007 and saved. this content By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks.

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