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. Fix ability to open XML files

    Up until Dec 2018 I was able to open an XML file directly in Mac Excel. Last week in Dec and still now I get this message: The file you are trying to open is not a valid Excel XML Spreadsheet.
    I am currently at Mac Excel version 16.20 (181208)

    4 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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
    • The latest excel for mac version took away the option in the insert tab to "Insert Comment". I phoned microsoft support and spoke with one

      The latest excel for mac version took away the option in the insert tab to Insert Comment. I spoke with two microsoft support technicians and after they did a very diligent job of trying to find the Insert Comment option in the tool bar, the last technician advised me to report the problem to this site. I do not use a mouse so that option is not available to me. Please add the Insert Comment option back to the Insert tab.

      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

        2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
      • Unable to create a Pivot table from multiple tables in Excel for Mac - seriously???

        Create a pivot table from multiple tables (feature appears to be missing from Excel for Mac!)

        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

          0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
        • Fix copy & paste bug when Handoff (Universal Clipboard) is enabled

          When Handoff is enabled (which also enables Universal Clipboard) and you are signed in to iCloud on your Mac and a nearby iPhone or iPad, Excel will freeze when you try to copy any cell. The spinning beachball will appear for 3-4 seconds and you can't do anything while this is happening. The bug also affects Word. This happens even on a Clean Installed system so it is not a 3rd party conflict.

          I've posted more details and a video of this happening on the Microsoft Community Forums:
          https://answers.microsoft.com/en-us/msoffice/forum/all/copy-cmdc-causes-spinning-beach-ball-delay-for-3-4/36e2e400-59c7-471b-b7d6-b5d5082a545a

          I've tried to report this bug but it seems impossible to…

          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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
          • The new comment threads, recently introduced in windows excel, are not compatible with the latest 2019/office 365 excel program.

            Excel needs to be compatible between platforms. Unfortunately we are now experiencing data loss because of the approach Microsoft used to implement the threaded comments capability.

            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

              1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
            • Bring filtering charts to Excel for Mac

              Bring filtering charts to Excel for Mac.

              I read about this feature here: https://blogs.office.com/en-us/2014/02/04/filtering-charts-in-excel/

              But I couldn't find how to use them in Excel for Mac (16.12).
              I found https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/chart-filter/e5e49410-6ffc-499f-bdeb-e6f8a151bd4c which claims they are not supported. This would be a useful feature to bring Excel for Mac closer to Excel for Windows.

              38 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
              • Be more forthcoming about the lack of parity with the Windows product in your online advertising

                When I visited the Microsoft website trying to decide whether to update from an 11 year old application suite (Office 2008 for Mac), learn to use Apple's own suite of applications for the Mac (Numbers and Pages—I'm already competent in Keynote and have abandoned PowerPoint), I read things that intimate that Mac users are "getting some things first"; e.g., in Office 2019. It's not clear what we're getting other than a new moniker.
                It's certainly clear in my first day or two of my 30 day trial that much has changed, but when I try to delve a bit deeper…

                4 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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
                • 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
                  • it will be more convenient if Excel for Mac has the same import xml function as Windows version.

                    it will be more convenient if Excel for Mac has the same import xml function as Windows version.

                    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

                      0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                    • solver multiple range

                      Using Solver, you cannot select multiple ranges in the "By changing variable cells box. If you select a range, type "," and select another range, the first range is overwritten rather than appended as in the Windows version of Excel.

                      Version 16.12

                      34 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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                      • Recent Files

                        Behaviour of "recent files" appears to have changed dramatically with the latest release. The list is empty since the update, and the "Recent Files" Windows refers to a login, but provides no mechanism for login. You are mucking around with the workflow of your users. Why would you make these changes?

                        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

                          1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                        • add find all

                          when you search to find something, make it so you can select all instances of it at once

                          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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                          • Pivot Table - Add the option to "include new items in manual filters"

                            Include the option to add new items in manual filters (same as the one that exists in the windows version)

                            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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                            • Improve Excel for Mac performance

                              Please improve Excel performance. I have Microsoft for Windows opened in a virtual machine alongside Excel for Mac. And despite limited resources Excel for Windows performs MUCH better.
                              For example when I put any value in a cell and hit enter and do it multiple times in a row then I experience a noticeable lag. There's no lag when I use the Windows version for the same file.

                              4 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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
                              • Enable Excel for Mac to connect to list data in SharePoint Online

                                It is currently not possible to connect Excel for Mac to data in a SharePoint list. That makes both Excel and SharePoint less functional in a wide variety of organizations, and makes SPO lists essentially useless in environments where they're updated from time to time.

                                Microsoft has developed a robust sync tool that works between Mac and SharePoint Online. Perhaps that could be adapted in a unidirectional way?

                                In any event, please consider for development.

                                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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                                • Import XML into excel

                                  I need to import a structured xml file into excel. The xml file contains elements which contain other elements. I'd be happy to define a mapping which would excel allow to know, which elements/attributes to put into which column. The File I'd like to import is attached. However, this is jus one example.

                                  9 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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Make Distinct Count available in value field settings for Pivot Tables in MAC

                                    make Distinct Count available in value field settings for Pivot Tables in MAC

                                    10 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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Adding notes to formulas?

                                      Formulas can get extremely messy with messy data. This is especially true when a formula is 10+ lines long. Often, re-reading a formula a few weeks later is absolutely indecipherable. Can we somehow be able to add notes to a formula, similiar to the ' in VBA?

                                      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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                                      • don't delete the list of recent files when updating

                                        don't delete the list of recent files when updating

                                        4 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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
                                        • disable horizontal scrolling

                                          Please allow users to disable horizontal scrolling (when trying to scroll vertically). When using two-finger scroll on a trackpad (like on a MacBook) it's impossible to pull straight down. There used to be a feature to disable this in Excel for Mac, but it has gone away.

                                          The reason for this is that normally we only need to scroll vertically and am finding the when I use the trackpad I often scroll horizontally as well without intending to.

                                          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

                                            1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Feedback and Knowledge Base