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. New tab on Pivot Table

    What I would like to see in Excel is this: When we create a PivotTable, and double-click an item it opens a new tab, it could be a window so we can see the details, and when we want, we just close the window , the way it is today is very annoying, have to be deleting the worksheets that are created

    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. 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 →
  3. Allow PivotTables to display data contained within the referenced cell without a function.

    It would be great if PivotTables could just display the numerical value of a cell in the "values" section without requiring a function such as count or sum. It seems there is a way to do it, either using a super convoluted PowerQuery or like 300 lines of code, however that seems highly inefficient when the values could just be a cell reference.

    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 →
  4. 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 →
  5. Enable pivot table range selection by right clicking the mouse button

    Stop making users go to the ribbon to select ranges. Allow right click on pivot table to select new ranges.

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

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Filter year, quarter, month, week, day in pivot without the need of helper column

    Right now, we need helper column to file month, week and day. Place make avaliable in grouping menu.

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

    14 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 →
  10. 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.

    46 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

  11. 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)…

    19 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 →
  12. 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

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

    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

  13. 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 →
  14. Create Pivot Tables connected to DAX Native Provider

    Currently, Excel Pivot Tables connects to Analysis Services Tabular data models trough MSOLAP Provider which writes MDX queries back to Analysis Services.

    MS Excel should be able to use the same provider as Power BI and Power View and natively write DAX queries back to SSAS with enhanced query performance.

    Currently the only way to use DAX queries is to write a DAX query in the MDX query windows while importing data into Power Pivot, dramatically increasing the file size, duplicating the data into a new data model and having to recreate DAX measures available in SSAS into Power Pivot…

    14 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 →
  15. Allow formatting done outside a PivotTable to apply to the PivotTable

    When i say select a column which includes data in a PivotTable and format the column, the PivotTable changes, but reverts back on refresh. Stop the reversion.

    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 →
  16. Include Power Pivot in ALL versions of Excel 2016 - not just certain subscriptions or perpetual licenses

    It doesn't make senses that Power View and Power Query are included in all Excel versions but Power Pivot is excluded from many popular subscription and perpetual license options. Power Pivot should be available for all versions of Excel 2016.

    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 →
  17. disable automatic grouping of dates and times

    This issue is far from resolved. MS before closing this item consider that (arrogantly speaking for the community)
    - auto grouping should be disabled by default
    - should be configurable at the app level not workbook

    Leave the item open for user community to comment against until such time that the manager that OK'd this has been burned at the stake for being so arrogant as to assume the general community wants/ed this.

    It is hard enough to get people moving in the right direction with data without you making such transitions HARDER not easier. WYSIWYG, I asked for 1…

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

    We’ll send you updates on this idea

    8 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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!

    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 →
  19. Add Filter to Pivot table

    In Excel 2016 I can no longer add a filter to the pivot table. I would like to be able to filter on more than just the Rows; I need to be able to filer on the values or columns as well. In previous Excel versions I could highlight the row above the pivot table and select all of the pivot data and apply a filter. In Excel 2016, this functionality is blocked and the Filter option is grayed out. Please bring back the ability to filter on columns and values.

    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 →
  20. More information for Err: "A PivotTable Report cannot overlap another PivotTable Report"

    More information for Err: "A PivotTable Report cannot overlap another PivotTable Report".

    I had multi PivotTable share the same data source in a single worksheet.
    This error had little meaning for me to find out which PivotTable having problem.

    Please improve the error message and advice which PivotTable cause this problem.

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

Feedback and Knowledge Base