Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Excel for Mac 2016 does not open xlsm files from Excel for Windows !

    Excel for Mac version 16.15 does not open xlsm files from Excel for Windows !

    Excel has a very serious error:
    Do not open the xlsm files maked with Excel for Windows, please correct it... !!!
     
    
I have tried it with all my previous excel macros files and in all it sends me a message of ERROR, when accepting that, Excel proceeds to repair it deletes all the macros that you have programmed in VBA !!!

    What kind of error is that ???

    PLEASE CORRECT THAT HORROR !!!! ...

    The exact message is the following:

    Notice: 
We have found a…

    20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  2. Bring VBA on Excel for Mac to parity with Excel for Windows

    Bring VBA on Excel for Mac to parity with Excel for Windows.

    Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

    Why is the not being addressed?

    94 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. screenupdating

    screenupdating = false fails in excel 16.13 again

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. macro options...

    If you select Tools - Macros - Macros... you get a list of macros. Select a macro and click Options... You're then presented with a box that allows you to set a Shortcut key. Either Option+Cmd (for a lower case letter) or Ctrl+Shift (for an upper case letter).

    It doesn't matter what I enter into the little box. Nothing works. No letter, upper or lower case, seems to work.

    Since generally keyboard shortcuts seem to be an issue has this ever worked?

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. VBA bugs

    Hi. Thanks for providing a new VBA editor for Office 2016. I have a vba add-in I've been working on that shortly after some recent updates started having errors pop-up. Please fix Mac Office 2016 so in vba I can close open xlam files.

    In the attached add-in, I install statprogo.xlam, then in the ribbon, I can select, eg, Regression Analysis->Multiple... and then press cancel on the user form to get the error. The workbooks().close call is causing the error when it did not previously.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add the same items in the developer bar as in windows. Many VBA commands are missing, such as insert form

    add the same items in the developer bar as in windows. Many VBA commands are missing, such as insert form

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. User defined functions

    I developed an Excel Add-in that is coupled to a Fortran code in Excel 2016 for Mac. This works perfectly. However, it would be nice if the list of (user defined) functions could be visualised in a separate category or visualised anyway in the "Formula Builder" pane on the right side of the screen (in between the already existing categories and functions). I tried to use

    Sub AddUDFToCustomCategory()

    Application.MacroOptions Macro:="MyFunction", Category:="MyCat"
    

    End Sub

    but that does not work, nor in my develop Add-in, nor in a very simple Add-In with only one simple function.

    Looking forward to an answer!

    Teus

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. why Excel VBA on mac disapere ? :-( :-( :-(

    a BIG mistake ! (and stupid too)

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. why Excel VBA on mac disapere ? :-( :-( :-5

    a BIG mistake ! (and sutpid too)

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow attaching symbols to quick-access toolbar buttons (as is the case in Excel for Windows)

    For many years I had a customized set of buttons in the toolbar at the top of Excel spreadsheets. Some of these were standardized commands (splitting the worksheet); others were macros I had created. These sped up my work significantly. I had hoped to use the Quick Access Toolbar in Excel for Mac 2016 to recreate the most important of these. I can do this, but they all have the same button symbol!! Could you allow me to replace the buttons with symbols, as I could in Excel for Mac 2011 and apparently could if I used Excel 2016 for…

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Please, let us modify the Ribbon and the Quick Access Toolbar in VBA 2016

    The menus are gone in VBA. Goodbye. But there's no replacement for these menus. It's not possible, when loading a workbook, to modify them.I know you work hard to implement these properties. Thank you. It's urgent.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  12. Various Bugs in VBA Editor

    In Excel 2016 Mac build 171017


    1. Trying to Import class file... When file dialog appears, you cannot select a .cls file. Clicking on the Options button show "Enable VB Files (.frm, .bas, .cls)" This should work, but class files still cannot be selected. Changing the list to All Files (.) still doesn't work. Changing the list to Class Files (.cls) works and you can select a .cls file.


    2. Exporting a class object to a file defaults to Untitled.cls instead of the name of the class. (Same is true for modules)


    3. Editor should default to a monospaced…

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. I have Excel 365 for Mac. I want to have a KEYBOARD SHORTCUT for FIND & REPlACE! I sorely miss the one I used on Excel 2011.

    I have Excel 365 for Mac. I want to have a KEYBOARD SHORTCUT for FIND & REPLACE! I sorely miss the one I used on Excel 2011.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. Fix Solver Solving Method drop down in Mac Excel 2016

    The drop down for select Solving Method in Solver does not work in Mac Excel 2016. Nothing happens when one clicks to reveal the drop down menu.

    One can select an alternate solving method via the arrow keys. Please fix the Solver drop down.

    Thank you.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow Userforms that are modeless

    Allow Excel for Mac to support Userforms that are modeless, so that the Userform will not interrupt editing of the worksheet while the user form is shown.

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Expose a VBE add-in entry point

    The VBE on Windows is reading a registry key to know where and how to load VBE add-ins from; that key is the ProgId of a COM-registered class that implements the IDTExtensibility2 interface.

    It is my understanding that Mac-VBA supports the VBE Extensibility library; if that is indeed the case then there should be a way to write a VBE add-in that can run on the Mac-VBE, and use that extensibility API to provide additional functionality, integrated in the editor. The mechanics would obviously need to be wildly different than on Windows, but there must be a way for the…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. ComboBox menu in UserForm partially hidden for the user

    In recent version 15.38 (170902), ComboBox menu in UserForm appears in the background of a UserForm and is therefore partially hidden by the UserForm itself (and not accessible by the User).
    See attached file.
    Sincerely

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Solver in Excel for Mac gives wrong answers to problems with binary variables. I teach an optimization class where this is a big problem.

    Solver in the latest version of Excel for Mac gives wrong answers to problems with binary variables. I am a professor and I teach an optimization class where this is a big problem. Running Solver in the attached file (and many others) generates wrong answers in the latest Excel for Mac. It works fine in other versions of Excel, including Excel for Mac 2011.

    25 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. I still cannot use "Add-in" on my mac

    I've already sign the "add-in solver" in the Excel add ins options. But I still cannot use the Add-in took kit that windows have.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. vba ODBC connection

    ActiveWorkbook.Connections("ConnectionName").ODBCConnection is broken. Please fix this single command. It is a blocking issue. All other ODBC commands are working as expected. Please fix this one so everything is working. Thanks

    20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base