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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. Comments on Pivot Tables

    Hi

    I would either like the ability to put comments on individual cells within a pivot table (and eventually retrieve this)

    Using PTs a lot to cross check and make notes about what needs fixing but filtering a long PT doesn't filter the associated rows outside of said PT to keep comments aligned

    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. 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 →
  14. 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 →
  15. Multiple pivot table on same data to have different grouping

    Allow pivot table to be independent - changing grouping etc. or even updating on one should be independent from the others. A common example is wanting different data grouping on different pivot tables.

    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. 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 →
  17. 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 →
  18. Pivot Table Additional Feature

    In the Pivot Table Field Settings - it's usually a pain having to always refer to the main field section to drop any column especially in the Value section where we have recurring details - hence the need to have like a tooltip drop down to change the columns not having to remove the former and then have to go drag and drop the next (e.g. in data involving daily sales in columns) - see image for clarity

    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. Timeline slicer breaks with spaces in blank cells

    HI MS

    It appears as though the timeline slicers are breaking when there is a space in a blank cell. This is frustrating as it is difficult to fine because the cell appears to be blank. Can you fix this or do i have work around it a trim/clean formula?

    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. Add selected hierarchy level from PivotTable fields with drag and drop (instead of top level)

    Drag and drop of a hierarchy sublevel from the PivotTable fields list to Filters/Rows/Columns should show the selected level.

    Example:

    We have a region hierarchy with two levels, continent and country.
    In the PivotTable Fields list, we see the field Region Hierarchy and can expand it to see the two fields Continent and Country.
    When a user wants to see the countries, he will drag the Country field to the Filters/Rows/Columns.
    But Excel always puts Continent there and then the user has to drill down to Country or hide the Continent field from Rows/Columns.

    So Excel should drop the selected…

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

Feedback and Knowledge Base