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.

How can we improve Excel for Mac?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 1 vote
    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 →
  2. Include the shortcuts for Fill commands

    Include the Windows shortcuts for Fill commands

    1 vote
    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 →
  3. 1 vote
    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. 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 →
  5. Bring back all the macro features lost in 2011 and 2016

    With 2011 and especially 2016 many of the vital functions in VBA recording and editing were lost making the writing of VBA macros impossible. User forms, debugging and relative referencing were three such features lost.

    I used VBA to add features not available in Excel. As a transcriber of old church records I enter a lot of pre 1900 dates. These must be in a special dd mmm yyyy format which used to be checked by macro. I also check other fields for CAPITALISATION and Proper Case. None of this is now possible.

    The advanced issue of a new version…

    29 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 →
  6. Add the object, property, method help available in Excel for Windows with the F1 key to the Mac 2016 version.

    Add the link to the "msdn.microsoft.com/en-us/vba/excel-vba/articles..." which is available in the Windows version of Excel while using the VBA editor by pressing the F1 key to Mac Excel 2016.

    Thank you.

    1 vote
    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 →
  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

    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 →
  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 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.

    15 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. 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 font…

    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 →
  12. 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 →
  13. 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.

    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 →
  14. Ability to use code-signing certificates

    On the Windows side, we sign our XLSM files with a code-signing certificate and set Trust Settings to only enable macros in signed workbooks. Would be great to port this over to the Mac side, with a similar setting, bringing more convenience and security to users.

    1 vote
    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. 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 →
  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. ComboxBox menu partially hidden in UserForm is ShowModal property = True

    Correction of previous post...
    In recent update 15.58 (170902), ComboBox menu in UserForm (which ShowModal property is set to True) appears in the background of a UserForm and is therefore partially hidden by the UserForm itself (and not accessible by the User). It was not the case in the previous version (15.37).
    See attached file (replace the previous one)
    Sincerely

    1 vote
    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. Bring back the AppleScript menu

    It's easier to use the AppleScript menu than the Services menu to make shortcuts to the scripts. Script also starts up faster in AppleScript menu then in the Services menu. This is important when scripts are used in editing.

    1 vote
    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 →
  19. Uservoice at #excelissues, #msshame, #excelformac,... and social medias posts!

    the only way we can be heard, once MS does not care! Lets make all mac users aware of MS policy.
    We need to go out of MS universe, the only way we might be heard. It has been 2 years or more.

    1 vote
    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. ACTIVEWORKBOOK.SAVE

    When the program run and calls code "ActiveWorkbook.Save()" in Excel 2016 (version 15.32 ) for Mac, error "Microsoft Excel isn't responding right now. Do you want to wait or quit? " pops up.

    - The network drive is located in US
    - The MAC EI-Capitan / Windows are located in US

    We have tested the above code in Excel 2016 for Windows, Excel 2016 32bit ( version 15.22 ) for mac, they are working fine.

    The only problem is on Excel 2016 64bit ( version 15.32 ) for Mac.

    1 vote
    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 →
  • Don't see your idea?

Feedback and Knowledge Base