Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Drop down list works in excel 2010 but not 2007?

  1. #1
    Join Date
    14th December 2010
    Posts
    28

    Drop down list works in excel 2010 but not 2007?

    Afternoon all,

    I've designed a spreadsheet in excel 2010 that has a dropdown list and a macro attached to a button. These work fine in office 2010 but when another user opens the file using excel 2007, the macro encounters an error and the dropdown arrow has disappeared.

    Any suggestions what I can do to resolve this?

    I've tried changing the macro setting in excel but this didn't work.

    Not sure if this is the correct forum but seeing as a macro was involved I thought I'd try here first!

    Thanks.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    2nd March 2011
    Posts
    1

    Re: Drop down list works in excel 2010 but not 2007?

    I was having the same problem and came up with a workaround.

    If you name the ranges of the lists you are using and then use those names when sourcing the lists for the cells.

    Hope this helps.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    2nd May 2008
    Location
    Ubique
    Posts
    1,886

    Re: Drop down list works in excel 2010 but not 2007?

    If your dropdown is a data validation list and you have used a list on another sheet as the source, then you need to do what Tayt said, since versions pre-2010 cannot refer directly to a range on another sheet and the validation will simply disappear.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    14th January 2012
    Posts
    1

    Re: Drop down list works in excel 2010 but not 2007?

    It worked fine form me Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    19th January 2013
    Posts
    1

    Re: Drop down list works in excel 2010 but not 2007?

    The issue occurs when the Excel 2010 document that contains list type data validation and the values for the lists reside on OTHER worksheets. This functionality didn't exist in Excel 2003 but it is in 2007. Nonetheless, when the functionality is used in this manner, it does not work when the document created in Excel 2010 is opened in Excel 2007. 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


Thread Information

Users Browsing this Thread

There are currently 6 users browsing this thread. (0 members and 6 guests)

Possible Answers

  1. Replies: 29
    Last Post: August 24th, 2011, 22:03
  2. Replies: 19
    Last Post: September 22nd, 2010, 19:06
  3. Watch this: Create a drop-down list in Excel 2007
    By Dave Hawley in forum Free Microsoft Excel 2007 Tutorials
    Replies: 0
    Last Post: November 27th, 2008, 10:35

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno