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?

    2,183 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    488 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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…

    96 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add Power Pivot to it.

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

    43 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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

    32 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  5. Pivot Table Power User

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

    40 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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!)

    7 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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

    11 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  9. Remove all subtotals past and future rows in Power pivot tables

    The "Do not show Subtotals" button on Pivot table tools design view removes all subtotals currently in the pivot table but when you add rows it will keep calculating unwanted subtotals. The pivot table should remember the setting and Not calculate subtotals when adding new rows.

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

    21 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  11. bug on pivot graphics

    There is a bug on pivot graphics in the last version. Isn't possible to create any pivot graphic.

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  12. Bring back pivot table wizard

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

    48 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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.

    4 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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.

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  15. The new format for pivot table chart analysis is awful. Very limited in options from previous versions and I don't understand why.

    Need to role back pivot table chart analysis and options. Very limmited options from previous versions. I can't get the right look and don't like the loss of control.

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  16. 27 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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

    137 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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,396 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi all,

    We are glad to announce that the first phase of the project is available for Insiders Fast. At this stage we support refresh from text, CSV, XLSX, JSON and XML files.

    Refer to the following blog post for more details:
    https://blog-insider.office.com/2019/05/30/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now/

    I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.

    We have exciting times ahead of us!

    Guy Hunkin
    - Excel Team

  19. Page breaks (and other options) for Pivot table items

    We need the ability to have page breaks in pivot tables for each change in item like Excel on the Windows platform has. Right now I have to manually set page breaks with each change of the pivot table.

    7 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    260 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base