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. Link Pivot Table Timeline slicers with data slicers

    I use pivot tables with "normal" slicers and with timeline slicers.
    If you add two normal data slicers they interact with each other in that if you make a selection in one slicer it filters the possible attributes in the second slicer.
    If you use a timeline slicer and select a given period, this does not filter the normal slicers to show only valid attributes for that period and vice versa.
    I want to be able to select a time period and for the slicers to only show attributes which have a value in that period. At the moment I…

    3 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 →
  2. sort out protection for power pivot tables

    with a power pivot table one obviously wants users to be able to do certain fairly fundamental things like sorting the data if the filter button is available or refreshing the data (which will insert and delete rows and columns, but not play around with its format or the values.

    But the protection options available on the worksheet are too limited.
    There needs to be an option to protect the sheet but allow tables to be refreshed and sorted.

    This was a bit of a pain when this was not available with oldfashioned pivot tables, but with the use of…

    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. Add Grand Totals on Stacked Column/Bar Pivot Charts

    MOST of the time I do a Pivot Chart using stacked columns, I want to be able to see a Total for the entire stack. It should be a very simple, intuitive way to do it, but seems like a huge workaround for something that should be a given. Either as Data Labels or as an option to add the Grand Totals as a series to the PC.

    7 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 →
  4. Pivot table format division wise colouring and Merge centre

    On pivot table, a new format can be include to show a report in column and row.
    For eg: when a pivot report prepared for country/state wise, eg. India should be in Merge-center & its states should be in below row;

         India          
    

    TN KER KAR AP

    2 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 →
  5. Pivot table-change multiple value fields at once

    Allow user to change multiple value field settings (example multiple columns to sum) at one time. Would be even better if it could be done like right clicking to format cells.

    6 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 →
  6. Expand/Collapse function in pivot charts for the 'Legend' (Pivot Column Group)

    Expand/Collapse function in pivot charts for the 'Legend' (Pivot Column Group)

    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 →
  7. Add Roles to Power Pivot

    Currently, the "roles" functionality, which enables row-level security, is available in tabular data models and Power BI desktop. I would like to use this feature in Power Pivot. To elaborate, I'd like to load a full data set, and have Power Pivot filter the data model shown to the current user, based on their security profile. I can set this fairly quickly in Power BI Desktop, not sure why it isn't an option for Power Pivot.

    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. Add an option in "pivot table" to sort data same as the "original order"

    when creating pivot table it will sort data
    A-Z, Z-A, or MANUALLY
    it will be great if you add another option to allow the sorting the same order as they were. "original order"

    2 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 →
  9. when we create a pivot and draw down but when we have to convert all value from count to sum So, there were tick mark option to be given fro

    when we create a pivot and draw down but when we have to convert all value from count to sum So, there were tick mark option to be given fro

    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 →
  10. Completely non-numeric pivot charts.

    I work for an artistic company and we use excell to track the KINDS of items we need, character by character. For some characters, this might be organza or fur, others it might be foam or bolts. We want to be able to have distinct pages showing character by character, but also have up to date modifications if the kind of organza we use changes for all characters. In the past we had dozens of individuals pages (using slicers) and one main page, but they would not all get updated, so confusion ensued.

    We like to be able to easily…

    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 →
  11. make Pivot Table Filters/Columns/Rows/Values boxes stretchable in all directions.

    I'd like to see the Pivot Table Filters/Columns/Rows/Values boxes stretchable in all directions. They are too small to manage more than a couple fields.

    2 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 →
  12. Pivot Table Slicer Report Connection select/unselect all option

    Hi,
    Sometimes we have too many pivot tables and when we want to connect these tables into one slicer in report connections window we need to select each pivot table name one by one.

    My recommendation is on the top of the report connection window, there should be select all/unselect all option box.

    Thanks

    6 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 →
  13. Pivot Table Ability to: Count Distinct values of a field & Add a Calculated Field / Item in the same Pivot Table

    I encountered an issue today & had to create a workaround.

    I wanted to count the unique "Item ID's" in the Pivot Table, so I had to select "Add this data to the Data Model" to do so. The only problem is, when you select that option, I loose the ability to add a Calculated field off of that Unique Count in the Pivot Table (all of those options are grayed out). It seems like you have to choose one ability over the other, when I needed to do both. This seems like it would be exceedingly valuable, as many…

    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 →
  14. Slicers - Remove the selected criteria when a slicer is deleted

    Hi,
    Slicers are great tools to filter Table and PivotTable.
    But, when you apply a filter with a slicer and after you remove this slicer from your worksheet, the filter is still active. And it's a nightmare to find the slicer who get the filter.

    So, my suggestion, is to remove all the selections of a slicer when it is deleted.

    15 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 →
  15. Make quick measures like in Power BI available in Excel as well

    In Power BI we can easily create quick measures: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/
    This makes it so much easier for newbies or occasional users to adopt the new technologies, so please add in Excel as well.

    50 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 →

    Hi Imke & others,

    Thanks for logging this suggestion and voting on it. Yes indeed this would be very useful to make it easier and quicker.

    For those that’d like to get this done, please be sure to register your vote to help us prioritize against out backlog.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  16. Make slicers visible "On Demand".

    Allow the user to configure if the slicer is always in view or pops up on-demand. Activation/visibility could be triggered by selecting a visible report filter field or pivot table column header. Alternately, a report filter field could be configured to pop-up a slicer instead of, or in addition to the normal selection box. Another alternate would be to have report filter field style boxes independent of the pivot table range which would pop-up the slicer when selected. Lastly, a slicer selection panel could be added with a list of parameters to choose which would cause the slicer to pop-up

    40 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 →

    Hmm.. interesting thought, and I can see how useful this could be!

    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.

    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!

    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!Ashvini Sharma
    Lead Program Manager
    Excel

  17. Allow to disable the auto-compile for every DAX change in Power Pivot

    The DAX compiler takes more than a minute to re-compile the model each time I modify the DAX code, or if I change the datatype of a measure.

    This is with "Manual Calculation Mode" set, which if not set would take even more time.

    Sometimes, I need to change many measures in a batch way and it is very painful to have to wait a good 1 minute between each changes.

    A way to pause the compiler and modify many measure would be such help.

    Currently, I have about 1000 measures. Assuming I would like to beautify them (code indentation)…

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

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  18. Dependent filters in Pivot tables

    Have Pivot table filters cross filter each other like slicers can. With multiple filters on a Pivot table making a selection on one filter the choices in the next filter should only have values that still have data. An example would be if a Pivot table with sales data and filters for regions and districts. After selecting a region the district filter should only show districts related to the selected region.

    4 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 →
  19. Histogram from a pivot table

    I should be able to create a histogram from a pivot table and this should update whenever values in the pivot are changed/updated

    2 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 →
  20. Allow us to filter slicers

    I use Excel for connecting to tabular data models to create pivot tables with slicers. Our clients do not want to see blank slicer buttons or slicer options that are no longer valid (ie, a medical office location closed several years ago, but that data is still in our database to maintain historical scores). I have seen in PowerView that we can filter the slicer options to only display the ones you want. Would be great to have this in the desktop version of Excel. Thanks!

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

Feedback and Knowledge Base