Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Allow measures to be moved to different tables through Power Pivot's Diagram View

    Currently, the only way to move a measure to a different table is through the Manage Measures window, which is accessible from the Power Pivot tab in Excel. Also, the Manage Measures window lets you move only 1 measure at a time, which is a pain if you want to rename a Power Query table that is loaded to the Data Model, since you must move all of its measures to another table, rename the table, and move all of the measures back.

    Please allow measures to be moved to different tables through the Diagram View in the Power Pivot…

    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 →
  2. Fix the flickering tooltips for Power Pivot's Data View and Diagram View

    In the bottom right corner of the Power Pivot window, there are 2 icons, which represent the Data View and the Diagram View. If you hover over the icon for the Data View, a tooltip that says "Grid" appears and flickers. If you hover over the icon for the Diagram View, a tooltip that says "Diagram" appears and flickers.

    Please stop this flickering. Also, consider changing "Grid" to "Data" so that the tooltip is consistent with the Data View button in the Home tab of the Ribbon.

    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 →
  3. Distinct Count in Pivot Tables

    I wanted to group values in pivot tables, but also do a distinct count. Pivot table doesn't allow you to do both. Can someone please provide an update excel to perform this feature.

    6 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. Be able to insert a PivotTable or PivotChart from the Power Pivot tab in Excel's Ribbon

    Currently, the only way to add a PivotTable or PivotChart that is based on the Data Model is to use the "PivotTable" button in the Home tab of the Power Pivot window. This button should also appear in the Power Pivot tab in Excel's Ribbon.

    When I work with Power Pivot, I'll do all of the Data Model work first, using only a few PivotTables for debugging purposes, and once I am confident that everything is correct, then I'll go crazy with making all of the final PivotTables and PivotCharts. This involves a lot of back-and-forth with the Power Pivot…

    1 vote
    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. Do not show a red underline for valid DAX code

    There are at least 3 cases when Power Pivot shows a squiggly red underline for valid DAX code:
    • IN operator (e.g. "Some text" IN VALUES('Table'[Column]) )
    • Table constructor (e.g. COUNTROWS({"a","b"}) )
    • TREATAS

    Please remove the red underline for these cases and any other cases when the code is valid.

    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 →
  6. In DAX, combine aggregation functions with their iterator counterpart

    Many of the aggregation functions in DAX come in pairs. For example, SUM and SUMX, or MIN and MINX. The "not X" functions aggregate a single column and the "X" functions evaluate an expression for each row of a table and aggregate the results.

    Using SUM as an example, why not just have SUM act like both SUM and SUMX and then SUMX can be deprecated? If the 1st argument is a column name, then it should act like SUM. If the 1st argument is a table, then it should act like SUMX.

    This would greatly declutter the list of…

    1 vote
    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 →
  7. change measure name globally

    If you rename a Measure in Excel, that name change should automatically trickle down through any downstream measures that reference that initial measure like in Power BI, instead of simply breaking your model.

    As it stands, if I rename an upstream measure I also need to edit ALL instances of that name in downstream measures.

    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 →
  8. Suppress Zero Values in Pivot Tables

    Many other software programs that aggregate data in a similar manner as pivot tables allow or even default to an option that suppresses zero values. This would be extremely helpful to consolidate the table down when I am pivoting on data that has a lot of open dimensions that won't have values.

    2 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 →
  9. Make it easier to change sum(values) from sum to count

    Today when I change sum (values) from a sum to a count, I have to right click the field I added, and select "value field settings", which brings up a drop down that I then change to 'count'. I have to move the mouse quite a bit to complete this scenario - the right click is invariably lower right corner of the screen, and the dialog is in the center. If you are in a rush, or do alot of these, it tires your wrist out. Would be nice if I could do this without so much movement.

    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 →
  10. Sort Pivot Tables based on multiple columns

    I want to be able to sort various values I have selected in my Pivot table in addition to the rows and columns.

    For example, in a pivot table representing code coverage, I have class and function as my rows, for my values I have lines of code and the percentage of code touched. In order to see where I should best focus my efforts, I want to see the functions with the most lines of code and the least code coverage, so I want to sort first by LoC (descending) and then by coverage percentage (ascending).

    This doesn't appear…

    9 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 →
  11. Allow Dynamic Arrays to reference Pivot Table

    We often want to further do further calculations and data comparisons on pivot table results. While I'm sure there is lots to do "under the hood" to accomplish this, it would be great if a dynamic array formula could reference the results of a pivot table so further calculations could be made. Currently a "#REF!" error is shown.

    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. Add a modeless PowerPivot Measures Pane (or make the existing one modeless)

    Why is the PivotTable Fields Pane non-modal, but the #PowerPivot Measures dialog modal?

    I LIVE in that Measures dialog. I ALWAYS want to have it open. And I want to be able to park it permanently over in Monitor 1 where it can merrily not obscure my Dashboard like my Fields pane doesn't.

    1 vote
    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 →
  13. Pivot table case sensitive fields

    In Pivot Table field settings let the user choose the option "Case Sensitive", which will separate rows (or columns) that are grouped together because of the way Pivot Table deal with text fields.
    It is most important for Salesforce users that retrieve objects ID's which are case sensitive (in their 15 characters mode).

    3 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. Combined Slicers

    Having a lot of slicers gets messy and they take up a lot of room. It would be nice if there were an option to have all slicers live in one slicer window, with a dropdown or tabs at the top to select which slicer to view.

    3 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 →
  15. Change "PowerPivot" to "Power Pivot"

    Click on the Power Pivot tab in the Ribbon in Excel and click on Settings. In the window that appears, the old spelling "PowerPivot" is still used, even in the title bar.

    When you first open the Power Pivot window, a message that says "Preparing the PowerPivot window, please wait…" appears.

    The "This table has already been added to the data model" message also contains "PowerPivot".

    Please change "PowerPivot" to "Power Pivot" throughout all of Excel.

    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. Make Pivot Tables function more like Data Tables

    Data Tables are an excellent feature. From automatic extension to special range reference syntax to styles, they are a work of art. Please give pivot tables some of the same innovations. Replace GETPIVOTDATA with the table referencing syntax. Update the coloring to match the new table styles, or even better let us just use table styling on our pivots. Let us add columns via formulas in the worksheet instead of the calculated column dialog, just like extending a table. Oh and if we could have a non-vba way to auto-refresh them that would be great :)

    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 →
  17. Add ability to turn on Manual Calculation Mode in PowerPivot using VBA

    When adding measures to a data model using VBA, It starts to get real slow as the number of measures gets high. Seems like it might be evaluating all existing measures after each additional one is added in. If we could turn off the PowerPivot version of auto-calc using VBA at the beginning of the macro, that might allow it to suppress the evaluation and just do it once at the end.

    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 →
  18. Filter by color in PivotTable

    It's variety to filter than current.

    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 →
  19. Add a Compatibility category for DAX functions

    Ever since the introduction of variables to DAX, EARLIER and EARLIEST are no longer needed or recommended. Please move EARLIER and EARLIEST to a new Compatibility category to make their obsolescence clear to users. Over time, other functions will likely join these two.

    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 →
  20. AutoFit tables in Power Pivot's Diagram View upon double-clicking on the table's edge

    If the edge of a table is double-clicked, then the table should AutoFit in that direction (i.e. be as small as possible without cutting anything off). If the top or bottom edge is double-clicked, the table should be as short as possible without causing the vertical scroll bar to appear. If the left or right edge is double-clicked, the table should be as narrow as possible without cutting off the table name, any column name, or any measure name.

    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 →
  • Don't see your idea?

Feedback and Knowledge Base