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. Add PowerPivot to Mac excel

    is it possible to open an existing Windows Power Pivot Excel on Mac?

    I have already created a Power Pivot Excel report on Excel 2013.
    Now i want to use that report on mac.Is there any way to do so?

    1,520 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

      351 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    • Provide all the options that are available to Windows users

      MAC users are severely limited with what they can do in Excel compared to Windows users. I am doing an Excel course and creating a Pivot Chart is not an option for me nor do I have the option to create a PowerPivot as my classmates who use Windows PCs. All that needs to be done is to make things comparable. What you do for one- Windows PC users, you do for the other- Mac users. Level the playing field so to speak.

      It's not only about Pivot Tables. All Mac Excel applications and features need to be updated and…

      44 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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
      • Add Power Pivot to it.

        Add Power Pivot to Mac for Excel.
        I would be willing to pay an additional fee for it.

        25 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 →
        • Pivot Table Power User

          Bring Pivot Tables up to the same capabilities as the Windows version

          24 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 →
          • Make Distinct Count available in value field settings for Pivot Tables in MAC, just like Windows

            Make Distinct Count available in value field settings for Pivot Tables in MAC, just like Windows

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

              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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
              • PivotTable

                When I click into a PivotTable from out of it (just from out of it) or when I move the selected cell over a PivotTable and stop there in the moment the PivotTable Analyze and Design menus appear the keyboard arrows don't move anymore.

                If I click again over any cell of the PivotTable (i.e., when the menus are already loaded) I can use the arrow keys - what I think should be done automatically.

                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  ·  PivotTables and Power Pivot  ·  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!)

                  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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add support for Get & Transform (formerly Power Query)

                    Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)

                    3,002 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

                      799 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                    • Consolidate Multiple Data Sources in a Pivot Table

                      Allow users to aggregate data in a pivot table from multiple worksheets.

                      227 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

                        50 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                        Hi all – we are evaluating this request, but we want to find the best solution for your data analysis needs. It would be helpful if you would describe what you are trying to accomplish with your data so we can understand whether there’s a better way than by using the PivotTable Wizard to consolidate multiple ranges.

                        Please add your comments to the suggestion in Excel.UserVoice.com.

                        Thanks – Steve K [MS Excel]

                      • In PivotTable add the option to show subtotals only for rows OR only for columns, as is possible for grand totals.

                        In PivotTable add the option to show subtotals only for rows OR only for columns, as is possible for grand totals.

                        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  ·  PivotTables and Power Pivot  ·  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

                          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 →
                          • Sort on multiple columns in a pivot table. I can now only sort on one column

                            Suppose you want to sort on the second column from largest to smalles. And values in the first column (if they have the same value in the second column) you want to sort alphabetically. I can't find a way to do this in Excel for Mac.

                            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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                            • Please bring back "PivotTable and PivotChart Wizard" to Excel on Mac

                              PivotTable and PivotChart Wizard works well on Windows. It is important to analyze data. I am sure most us our missing it

                              14 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 →
                              • Bring back pivot table wizard

                                Why did this go away in excel 2016 on Mac? Bring it back I need it bad

                                28 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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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 →
                                  • 25 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 →
                                    • % of Parent Row Total and % of Parent Column Total

                                      Allow in Pivot Tables to calculate the percentage of items as part of a subgroup.

                                      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 →
                                      • F3 paste range name functionality for defining range in Pivot table range definition

                                        Paste range name dialogue box opens in general worksheet functionality, but does not perform when defining range in pivot table range selection.

                                        This short cut is invaluable for rapid multiple pivot definition.

                                        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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Median function on Pivot Tables

                                          Please add a median function for Pivot Tables. It is mind boggling how Google Sheets has this capabilities but the much more powerful MS Excel does not

                                          124 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

                                            5 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Feedback and Knowledge Base