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. Display pivot table headers in the columns headers

    With the tables, if the header is not visible, Excel displays the headers of the table in the columns headers (see the picture attached)

    It will be great to have the same behaviour with the pivot tables

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

    97 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 →
  3. Organize DAX Measures in Folders

    Users should be able to organize measures in folders and subfolders when configuring a Power Pivot using Excel's data model. This would be similar to the functionality available in SSAS Tabular.

    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 →
  4. Please allow functionality to turn pivot table to basic spreadsheet.

    It would be very flexible to be able to deconstruct pivot table into basic worksheet. This should break the connection and all pivot table propertiies. Of course it would be irreversible.

    4 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 →
  5. Document DAX with enough detail to not have to take a 3rd-party course to learn it

    Microsoft has done an OK job documenting the DAX functions, and this is fine for those that already understand DAX. However, there is little documentation to understand DAX in the first place and users must resort to taking SQLBI's Mastering DAX course to learn basic concepts such as context transition, data lineage, expanded tables, and the evaluation of CALCULATE. The current cost and effort required to learn DAX are a deterrent for anyone thinking of using DAX in their work, which hinders the adoption of DAX.

    Please lower the barrier to entry by thoroughly documenting DAX in a user-friendly way…

    3 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 →
  6. Power Query: Name new worksheet from "Load to…"

    It should be possible to name the new worksheet from the "load to…" function in Power Query. Any table that is created inherits the name of the query that produced it, but the worksheet always receives a default "Sheet1". For my purposes, inheriting the query name would be sufficient. Others may wish to name it from within PQ.

    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. Hide filter arrows (display option)

    Filter arrows should be able to be hidden in all tables (including PivotTables). This is especially applicable when using linked tables in a PowerPoint presentation.

    In the PivotTable Options > Display menu there is a checkbox for "Display field captions and filter drop downs". This should be split into two options: "Display field captions" and "Filter drop downs", with Filter drop downs having two sub-boxes: "Remove filtering" and "Show filter arrow when hovering". This would make the filtering arrow only appear when the curser was hovering over the box or it was the active cell.

    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 →
  8. Pivot Table Should Refresh Automatically on Create

    When an existing Excel Table is Resized, and a Pivot Table is inserted using this newly defined data range, the new Pivot Table does not include the columns newly added to the Excel Table, until the newly created Pivot Table is Refreshed.

    On Insert --> Pivot Table, the newly inserted Pivot Table should reflect the current state of the defined range, instead of a cached version.

    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. Use a Monospaced Font in the Power Pivot DAX Editor

    Switching to a monospaced font for the formula bar in the Power Pivot window could be an easy win to improve the DAX editing experience inside Excel and be coherent with Power BI, SSAS Tabular and external tools.

    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. Block copying entire PowerPivot data-model by copy/paste

    Even after adding IRM / encryption / protection etc. a user can copy the entire data-model into a new workbook by simple ctrlC,ctrlV.
    I.e. if you copy the full pivot-table area and paste it to a new workbook - the entire data-model will follow along including all the data!

    Only by setting "view only" rights can this be prevented - but that means user cannot use the pivot functionality or copy values from what they are looking up in that 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 →
  11. Be able to have pivot field in both filters and row/column

    Make it so a data field can be both in filters and the rows/columns.
    I would very much prefer to have all filters clearly illustrated in the top even though the data is used in 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 →
  12. Power Pivot Measures

    In PowerPivot Manage Measures table, I suggest to (1) add a column the measure is located (2) description of the measure.

    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. would like to use Power Pivot add-in

    cannot find Power Pivot - Please advise

    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. Please allow the ability to change pivot table source data connection

    I inherited a pivot table tied to a private database. I want to keep the pivot table but change the underlying data source. This is currently impossible so I'm having to recreate the whole thing from scratch.

    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. Plz make possible, Instead of calculated items and fields, we can write the formula directly in the pivot table.

    Plz make possible, Instead of calculated items and fields, we can write the formula directly in the pivot table.

    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. Unifying icons in the pivot table

    I found an inconsistency in an icon graphics in the PivotTable. Details in the graphic in the attachment.

    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 power bi features to excel

    I would like for excel to add all power bi features to excel for example cards tiles etc..

    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. Allow disabling of the Quick Explore feature

    The quick explore feature is cute, but it destroys the shape and format of the pivot table. I can't have some uninformed user selecting that icon and screwing up the worksheet as the entire pivot table changes and morphs with the new filters. Crazy! Allow it to be turned off, just like the drill down feature (enable show details).

    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 →
  19. Show Report Filter Pages for Data Model

    Show Report Filter Pages also for Data added to the Data Model of 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. Multilevel Add/Remove blank row after each item in Pivot Tables

    I have a tabular form Pivot Table with four Row fields. I would like a blank row after the end of the first and second fields, but not afterwards. With the 'Add a blank row after each item' command, I get a blank row between every line of data, rather than having the lesser fields grouped together with no blank line. I would like to be able to select a field entry and have the command add a blank line at the level of the selected field.

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

Feedback and Knowledge Base