+ Reply to Thread
Results 1 to 7 of 7

Dropdown menu does not open on Macbook

  1. #1
    Registered User
    Join Date
    06-28-2016
    Location
    -
    MS-Off Ver
    2011, built 14 on Macbook iOX
    Posts
    8

    Question Dropdown menu does not open on Macbook

    Hi,
    I have created an Excel spreadsheet on my Windows 8.1 computer (MX Excel 2007) with a dropdown menu. The dropdown works all right on the Windows machine.
    When I open this file on my Macbook with iOX 10.11 and Excel 2011, built 14 the following happens:
    * I can see the dropdown menu
    * I can click on / open the dropdown menu
    * I can see the content of the dropdown menu for a split second
    * The the dropdown menu closes again without another click from my side and I am not able to choose a different option from the menu


    * Macros are activated in Excel
    * When I click-and-hold, I can see all options in the dropdown menu but if I choose a different option, this still does not select the new option..


    Any ideas?
    Thank you very much!
    tauttillini

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Dropdown menu does not open on Macbook

    what kind of dropdown is it...is it activeX?
    if so activex does not work on Mac
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    06-28-2016
    Location
    -
    MS-Off Ver
    2011, built 14 on Macbook iOX
    Posts
    8

    Re: Dropdown menu does not open on Macbook

    Hi humdingaling and thank you for your response.
    I have no ActiveX elements in the spreadsheet.
    I do have makros though.
    The file works fine on Windows mashines but not on the Macbook iOX.

    Any further suggestions?
    Thank you!

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Dropdown menu does not open on Macbook

    please attach your file

  5. #5
    Registered User
    Join Date
    06-28-2016
    Location
    -
    MS-Off Ver
    2011, built 14 on Macbook iOX
    Posts
    8

    Post Re: Dropdown menu does not open on Macbook

    Here is the file, which is quite extensive.
    Go to the sheet "Charts" and try to select one of the 4 dropdown menus or to change the selected option. This does not work on my Macbook.
    Attached Files Attached Files
    Last edited by tauttillini; 07-04-2016 at 04:50 AM.

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Dropdown menu does not open on Macbook

    Hi,

    That is how the combo box controls behave in 2011. You must hold down the mouse to view and select the item you want. Your combo boxes do update to the new value but it takes a few seconds to reflect the change.

  7. #7
    Registered User
    Join Date
    06-28-2016
    Location
    -
    MS-Off Ver
    2011, built 14 on Macbook iOX
    Posts
    8

    Thumbs up Re: Dropdown menu does not open on Macbook - SOLVED

    Thank you xlnitwit - it works indeed!
    I used the spreadsheet on windows mashines until recently and only now switched to iOX. On the windows mashine it take only the split of a second to update the new value, that is why I was unsure whether there is sth about the iOX system that makes parts the spreadsheet useless.
    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] make dropdown menu dependent on other dropdown menu values
    By kosherboy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-30-2015, 04:29 PM
  2. How a drop down menu's list can change depending on another dropdown menu.
    By sudeepkm73 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-30-2015, 03:18 AM
  3. [SOLVED] How a drop down menu's list can change depending on another dropdown menu.
    By marc1980 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2014, 04:58 PM
  4. Replies: 1
    Last Post: 03-27-2013, 07:04 AM
  5. [SOLVED] Excel 2007 : new drop down menu based on dropdown menu in previous cell
    By martinpols in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 02:33 AM
  6. Create Dropdown menu without using the Validation on the Data Menu
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-13-2006, 03:47 PM
  7. dropdown menu or Jump menu
    By the dude in forum Excel General
    Replies: 1
    Last Post: 03-26-2006, 02:58 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1