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

    57 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…

      17 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

        3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
      • Listen to your customers

        There are several lines of discussion on the problems faced by people using Office 2016 & 2019 for Mac relating to VBA macro programming which have been ignored for a considerable time (at least 4 years). Microsoft need to do something about this. No relative ref control, userforms and dataforms are all missing and make the software unusable for serious work.

        Other software companies will fill this gap if you don’t!

        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 →
        • Easy or even just available data forms for data input on Office 2019

          We just need the basic data forms available to us! UGH it's ridiculous not to have that available and even readily available

          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 →
          • Allow tool tips for buttons embedded in a sheet that run macros

            This functionality (adding a tool tip) works if an embedded button operates a hyperlink but not if it activates a macro

            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 →
            • Enable Macros permanently for a given file

              Make my response on whether I want macros enabled on any given file part of the saved details with the file.
              I know it has macros - I wrote it and yes I want them enabled - always - every time I open this file. Ask me for the next file and remember my response for that one also.

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

                5 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 →
                • Fix ExportAsFixedFormat method

                  ExportAsFixedFormat method produces a "Run-time error '1004':

                  Application-defined or object-defined error" when trying to save (export) a pdf to a user folder (/Users/user/Documents for example)

                  As I see it only works if one saves to the sandbox path of Office (Library/Group Containers/UBF8T346G9.Office), which is quite uncomfortable to work with.

                  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 →
                  • Need a way to enter the static date and time on the iPad in excel

                    Definitely need a way to enter the static date and time on the iPad in excel. There is no command or control button on the iPad keyboard

                    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 →
                    • No forms in VBA what do people do now.

                      It was Microsoft who developed the UserForm capability in VBA for Excel and now it is gone - what do people do now.

                      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 →
                      • Screen Updating in VBA

                        It would be great if, as for the Windows version, the Mac version of Excel enables Screen Updating when running a VBA macro. Currently, starting a macro runs but there is no indication whether the application is indeed calculating or simply frozen. adding the command Application.ScreenUpdating = TRUE has no effect

                        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 →
                          • fuzzy lookup for Mac

                            Fuzzy lookup for Mac

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

                            140 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

                              46 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]

                            • 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

                              7 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 →
                              • Fix VBA recording issue

                                Something I came across - which I suspect has been documents elsewhere but I can't readily see it so here goes.

                                When recording a macro in excel for mac 2016 for some reason the action of opening a file does not get recorded. The recorder literally doesn't register that you have opened the file. (Its a very useful step to provide the full syntax for the file path of the relevant file).

                                However when you close the file - that step is recorded as ActiveWorkbook.Close.

                                It took me a while to work out that the syntax from 2011 to 2016…

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

                                  Thanks for reporting this issue, we are planning to address it, but in the meantime, you can do this with a command such as the following:

                                  Application.Workbooks.Open “/Users/user_name/Downloads/MyWorkbook.xlsx”

                                  Steve K [MS Excel]

                                • Quick Analysis for Mac

                                  Please include the Quick Analysis feature for the Mac version of Excel.

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

                                      5 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 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
                                        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 →
                                        • 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)

                                          648 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

                                            150 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]

                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base