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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    • fuzzy lookup for Mac

      Fuzzy lookup for Mac

      It would be great to have fuzzy lookup add-in for Mac.

      129 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        42 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

        Thanks for all your comments and votes supporting this suggestion. It would be very helpful if you would add more information about how you’d like to use fuzzy lookup in Excel.

        Thanks – Steve K [MS Excel]

      • 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

        19 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
        • Enable VBA Support for creating and editing UserForms (not the Data Form)

          In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.

          (March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)

          605 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            136 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

            Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

            I updated the title and description for this one and we’ll continue to monitor for comments and votes.

            Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality

            Steve K [MS Excel]

          • Bring back Relative References in Macro Recording

            In Mac XL 2011 You had ability to create Macros that made use of Relative References in a addition to absolute references. In the Excel Mac 2016 Answers forum this is vitally important.

            Any possibility of returning this to Excel Mac 2016

            [10/22/2015 - Dan [MS]: Added image to show where this feature used to exist in older versions of Mac XL]

            302 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              126 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
            • 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?

              46 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
              • 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…

                12 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                • Excel for Mac Macro cannot record data analysis operations

                  Excel for Mac's macro cannot record my operations when I use data analysis tools(e.g. using random number generation),but when I do the same steps on windows it can be done.
                  Could please fix that
                  Details pls follow the link
                  https://www.youtube.com/watch?v=x0vygE2JN4o

                  2 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                  • Mouse cursor disappears after running a macro in Excel for Mac version 16.15

                    Need to fix a bug with mac Excel. After running a macro, the mouse cursor disappears. It reappears after typing in another program and coming back to Excel. This fix works sometimes but not all. This gets frustrating. The same macro runs fine in Windows Excel.

                    3 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                    • 1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                      • macOS Mojave is only 64 bit update Excel 2011 to 64

                        At present if you want to use Forms in VBA you cannot in the latest version of Excel for Mac one has to stay with 2011

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                        • Include the shortcuts for Fill commands

                          Include the Windows shortcuts for Fill commands

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                          • 1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                            • screenupdating

                              screenupdating = false fails in excel 16.13 again

                              2 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                              • 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
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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

                                  6 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 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.

                                      3 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 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
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base