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. edit data from pivot table

    Give me the ability to edit the source data from pivot table (instead of opening a copy).

    This would be huge b/c it would open up using Pivot Tables as a flexible UI, not just analysis.

    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 →
  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. 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 →
  4. 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 →
  5. Power Pivot: Make 'Hide from client tools' also hide columns from drill-down

    Data models often include helper columns, which can be hidden from pivot table available fields using 'hide from client tools'.

    However, if the end-user wants the underlying data and uses the drill-down functionality of a pivot table (double-clicking one of the values to open a new sheet with underlying data), they are presented with every column in that table in the data model.

    The 'hide from client tools' option works to hide them from available fields in the pivot tables, but it would be nice if it also removed those columns from the new sheet of raw data created when…

    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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. Percentile added to pivot table functions

    Please please please add the percentile function to Pivot Tables! I spend spend so much time manually calculating percentiles.

    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 →
  13. 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 →
  14. 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 →
  15. Add box to specify name for PivotTable at creation, rather than after

    When adding a PivotTable (or the non-Pivot variety of table for that matter) it would be helpful if the box that confirms which data you want and where to place the table would also allow a name to be specified at this point.

    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 →
  16. Bring Power Pivot closer to Power BI Desktop Functionality

    Development for Power Pivot for Excel seems to have stopped around 2016. TREATAS got added as a DAX function that works, but it never got added to Intellisense, and that was nearly 3 years ago.

    Today, the two measure editors (still no idea why there are different ones) are a very VERY poor substitute for the fantastic DAX editor in Power BI Desktop. It is a real pain to properly tab and indent in the Excel Measure editor(s).

    In the last year there have been about a dozen new DAX functions and several updated functions per https://docs.microsoft.com/en-us/dax/new-dax-functions but NONE of…

    32 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 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. List TREATAS as a DAX function

    As SQLBI points out on their DAX Guide page for TREATAS (https://dax.guide/treatas/), TREATAS can be used in Excel but does not appear in the list of functions or in IntelliSense. Please treat TREATAS the same as the other DAX functions that Power Pivot supports.

    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 →
← Previous 1 3 4 5 12 13
  • Don't see your idea?

Feedback and Knowledge Base