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. Select Pivot Table by name

    I would like to have the possibility to select a PivotTable by name.

    In a PivotTable chart, the source tells you what is the PivotTable name but then, you have so select all your PivotTables one by one to find the correct PivotTable.
    So if you can add a tool that is able to select a PivotTable by name, it will save a lot of time.

    Thanks

    11 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 →
  2. 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 →
  3. Excel should add automatic "Dashboard" templates design as an option in its template area

    Excel should add automatic "Dashboard" templates design as an option in its template area

    3 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. Include database search functions like AND / OR / NOT in the pivot table search function within the filter section

    In databases when searching for key words you can use filters like AND, OR and NOT to refine your search. When using the filter section of a pivot table to search for key words this function is not available which means if you search for the word 'strength' for example but would also like to include 'strong', this must be done in independent searches with no way of knowing which results include both words.

    remedying this would make the search function more efficient.

    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 →
  5. 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 →
  6. 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.

    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 →
  7. Show pivot table total above heading

    Often there are hundreds or thousands of rows in a pivot table. To see the column total we need to scroll to the bottom of the report. Please add an option to show the column totals above the headings

    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 →
  8. 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…

    8 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. Create a formula to Display Data Source of Pivot Tables

    I work with numerous pivot tables within one worksheet. Some have the same data source to generate the pivot table and some do not. It would be extremely beneficial if there was a way to display the source of the pivot table within a cell to use as a reference value. So create this either by a separate formula that displays the source criteria or if that is too difficult, maybe just allowing this to be a feature of the PivotTable Options and allow to 'show source' at the top of the pivot.

    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. Add "Change Source Data" button to context menu for pivot table cells

    Simply add a button to the right-click context menu for cells in a pivot table to refresh the pivot table. Having to go up to the ribbon (or Alt hotkey) is annoying.

    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 →
  11. In DAX, allow variables to be named "Dimension"

    In DAX, you cannot have a variable named "Dimension", despite "Dimension" not being a keyword or the name of any function. Please allow variables to be called "Dimension", or if this is not feasible, at least add this restriction to the documentation.

    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. Change "PowerPivot" to "Power Pivot" in the PowerPivot Settings window

    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. Please change these to "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

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  13. In DAX, allow comments to exist at the beginning and end of a measure

    Currently, if you try to add comments to the beginning or end of a measure, the comments will be silently removed when the user is done writing/editing the measure.

    For example, in the measure below, the //1 and //3 are removed.
    Test:= //1
    (

    0 //2
    

    ) //3

    Interestingly, if you have a calculated column that is written similarly, such as the one below, then no comments are lost.
    = //1
    (

    0 //2
    

    ) //3

    Please fix this issue.

    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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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…

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

    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